Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables Expand / Collapse
Author
Message
Posted Thursday, February 20, 2014 5:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 20, 2014 4:57 PM
Points: 1, Visits: 3
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.
Post #1543769
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse