Friday, March 23, 2012

How to Create CSV File Using SSIS

Hi ,

I need to create a CSV file by reading a table data , Can any one know how i can do this using SSIS .

My Requirment is that -

I have a temp table in which i inserted all the incorrect data during the load of a flat file using SSIS. Now i need to write all the incorrect data of the temp table in a CSV . Is there is a way i can do this using SSIS , Please help as i am new to SSIS.

Regards,

Ashish Soni

Create a data flow with an OLE DB source that reads from your table and a Flat File destination that writes to a CSV file.

http://msdn2.microsoft.com/en-us/library/ms141668.aspx

|||Thanks Matthew for the help and support.sql

No comments:

Post a Comment