Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a .csv file in DTS

Status
Not open for further replies.

snowingnow

Programmer
Jun 1, 2006
32
CA
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
 
Use the "Text File (Destination)". Note that if you say C:\ for the output it will go to the SQL server C drive.
djj
 
but how can i export the column name in the csv file as well?
 
After you give it the filename select properties and check first row has column names.
djj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top