Hi,

I've created a simple DTS package to export a content of a table to a .CSV
file.
I would like to that columns in CSV file will be named as the Column names
in the SQL table.

It that possible to do that and how it can be achieved?

Thanks,

Barak

On the properties of the text file when you are setting it up is a checkbox
for "First Row has Column Names". Check that and you should be OK

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Barak Turovsky" <baraktur (AT) mail (DOT) ru> wrote

When you set up the connection to the text file click the Properties button below the filename. From Text File Properties dialog box, check the "First row has column names" checkbox.