Home Forums Data Warehousing Integration Services SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables RE: SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables
spencer.young
Grasshopper
Points: 13
More actions
February 20, 2014 at 5:04 pm
#1690927
The solution is to convert these types of stored procedures to table valued functions. Jamie Thomson wrote a nice article about this very problem in 2006 which has now come to the forefront in SSIS 2012.