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