Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), Temp tables Rss

   Items 1 to 3 of 3   
 

Using Temp Tables in SSIS

emporary tables are created in the Temporary tables are created in the TempDB database, which persists for a particular session. The objective is to maintain that session, until the temp table information is used and dump the data into a physical table.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,501 reads

SSIS and Stored procedures using temp tables

SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.  Read more...
Rating: |  Discuss |   Briefcase | 12,890 reads

How SSIS and Other Tools Obtain Metadata

How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.  Read more...
By Renato Buda 2008/11/03 | Source: SQLServerCentral.com | Category: fmtonly
Rating: |  Discuss |   Briefcase | 7,235 reads
   Items 1 to 3 of 3   
 
Tags
fmtonly (1)    
metadata (1)    
stored procedures (1)    
temporary tables (1)