importing data to csv file

Question

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.

 

Answer 1

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

Answer 2

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

Answer 3

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.html

---

http://www.rad.pasfu.com