Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Export include column headers

Author  Topic 

SoftFox
Starting Member

42 Posts

Posted - 2008-05-19 : 09:27:13
When using DTS to export from a view to a .csv file, is it possible to get it to export the column headers in the top row of the .csv file?

SoftFox
Starting Member

42 Posts

Posted - 2008-05-19 : 10:03:08
Found it. Option is in properties of text source destination in DTS package. Tick "First row has columns."
Go to Top of Page
   

- Advertisement -