SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Flat File Connection Rss

Search for any content tagged flat file connection

   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 | 15,880 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,378 reads
   Items 1 to 2 of 2