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 «««123

SSIS and Stored procedures using temp tables Expand / Collapse
Author
Message
Posted Wednesday, June 27, 2012 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 21, 2012 9:05 AM
Points: 1, Visits: 5
EXCELLENT ARTICLE !!!!!

Saved my day.

Thank Michael Cape

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/65112/
Post #1321985
Posted Tuesday, October 22, 2013 6:20 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:48 AM
Points: 1,935, Visits: 10,956
The answer (in SQL 2012) is to use the 'WITH RESULT SETS' option on the EXEC statement.

See http://technet.microsoft.com/en-us/library/ms188332.aspx for specifics.


Rob Schripsema
Accelitec, Inc
Post #1507432
Posted Tuesday, October 22, 2013 6:28 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:48 AM
Points: 1,935, Visits: 10,956
http://technet.microsoft.com/en-us/library/ms188332.aspx

Rob Schripsema
Accelitec, Inc
Post #1507435
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse