I would if I could, but the production server that I am working...

I figured out the source of my issues......

Since I was building my SSIS package from an existing package (similar use case, ETL data and export data to a business partner),...

Phil,

I tried the "IF 1=0" method and there was no change in the results of executing the Data Flow task (i.e. I am still getting the same error).

Thanks for the...

Yes, I am using a TEMP table in my SP to gather the data, and then I return the contents of the TEMP table.

I am receiving a similar error in an SSIS package that I am writing. The package connects to my MS SQL Server 2005 SP 4 database and executes a Stored...