I have created the SSIS package I needed using VS2008. It works using ADO.NET as destination.

I was confused by the answer. I guess your using vs2008 and I'm using vs2005. Many of our servers are 2005. From my understanding I can't create in vs2008 and...

Thanks for the assistance. I have spent a couple of days redoing the query. Not able to exclude the customer # before without exceeding the spool space limit. Am able...

Thanks for the reply. Unfortunately the tables are vary large and in breaking up the query I exceed the spool space limits in Teradata for the userid executing the query...

I cannot create a Stored Procedure. Sql is going against corporate TERADATA database, not allowed to create function on the system.

Thanks for the reply. I am going against Teradata and using a merge join with sql server table. I created 3 variables for the Teradata query due to the length...

I do this quite often. You must have the Teradata driver on the server your running on, or the PC your running on. I just use the sql I...

Found the answer. Error occured while writing to the output not from the datareader source. Thought it would be considered as one action.

Does not seem as though I can redirect...