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), Flat File Connection Rss

   Items 1 to 2 of 2   
 

Using SSIS to Capture the File Name

This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.  Read more...
Rating: |  Discuss |   Briefcase | 14,824 reads

Creating packages in code - OLE-DB Source to Flat File File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.  Read more...
By Additional Articles 2009/02/10 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,088 reads
   Items 1 to 2 of 2   
 
Tags
etl (1)    
for each task (1)    
ole-db connection (1)    
transformation (1)