How to create a .csv file in DTS

[snowingnow]

I would like to create a DTS which to query tables in database and export result as .csv file, how can i do this.
Thanks

 

[djj55]

Use the "Text File (Destination)". Note that if you say C:\ for the output it will go to the SQL server C drive.
djj

 

[snowingnow]

but how can i export the column name in the csv file as well?

 

[djj55]

After you give it the filename select properties and check first row has column names.
djj