nshockley (5/29/2015)
On SQL Server 2008 R2 some SSIS packages created and regularly scheduled to run have worked perfectly for over a year.These packages have been upgraded on our new 2014 server ... now some fail with the issue that the Stored Procedure executed in a Data Flow task cannot handle the Temp tables that are used. Error is basically that it cannot get the metadata for the columns of the temp tables.
Since these packages do actively work in 2008 R2 ... I am thinking there is some way to get them to work in 2014 also.
Does anyone know what the trick might be?
Thank you in advance for your ideas or solutions.
Things changed in SSIS 2012 and later and the trick is to use WITH RESULT SETS when calling your proc. See an example here.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.