How get column headers in QA CSV export

Using Query Analyzer and SS 2000, if I export a query result set of a
SELECT to a CSV file is there any way to get the column names included as
the first line of the file?
Bill Todd
Bill Todd wrote:
> Using Query Analyzer and SS 2000, if I export a query result set of a
> SELECT to a CSV file is there any way to get the column names
> included as the first line of the file?
You can use the DTS import/export wizard for that.
David Gugick
Imceda Software
www.imceda.com
|||The only thing I have been able to get the DTS wizard to do is display the
error message "the value for a required parameter is missing" which is
really helpful. Is there any documentation for the beginner for DTS?
Bill Todd
David Gugick wrote:

> Bill Todd wrote:
> You can use the DTS import/export wizard for that.
|||Bill Todd wrote:[vbcol=seagreen]
> The only thing I have been able to get the DTS wizard to do is
> display the error message "the value for a required parameter is
> missing" which is really helpful. Is there any documentation for the
> beginner for DTS?
I'm not sure what problem you are having. The wizard is pretty simple to
use:
1- Select a server and a database
2- Select Text File as the destination and enter a text file name for
the output (CSV entension)
3 - Click Use a query to specify data to transfer
4 - Enter query, such as: Select * from sysobjects (or use query
builder)
5 - Click Delimited, Column Delimiter = TAB, and First Row Has Column
Names
6- Click Run Immediately (and possibly save DTS package for future use)
The file should be created in CSV format. Let us know if you have any
problems.
David Gugick
Imceda Software
www.imceda.com