Hi Team, i want to import data from a table to a .csv file i am very sure how to do this the source/destination connection, what components to be used for destination(csv). Please help me with an example or any forum which has the examples, thanks in advance Regards, Eshwar.

you can use oledb source connecting to your database table and flat file destination to destination csv and do mappings correctly. or also you can use Import/Export Wizard just set source as database, and destination as csv flat file.http://www.rad.pasfu.com

Thanks Reza, I am able to do.. but how to handle the "," with in the data like if address has a comma within it then data after comma will go to other fields. Regards, Eshwar

Thanks Reza, I am able to do.. but how to handle the "," with in the data like if address has a comma within it then data after comma will go to other fields. Regards, Eshwar you probably have your fields qualified with text, and to overcome the comma inside values issue, I had complete sample here to solve it: http://www.rad.pasfu.com/index.php?/archives/13-Problem-with-comma-values-in-Comma-Delimited-File.htmlhttp://www.rad.pasfu.com