simple DTS question

#1

I'm exporting ( dts package) a query to a csv file, how do I get the
column names in the file.
I get the data but no column headings.

Thanks in advance

#2

<paulhux174 (AT) hotmail (DOT) com> wrote

Quote:

I'm exporting ( dts package) a query to a csv file, how do I get the
column names in the file.
I get the data but no column headings.

You could use a UNION query with the first select inserting the column names
followed by your current select.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#3

Hello paulhux174 (AT) hotmail (DOT) com,

In the properties of the Flat File destination is a checkbox that says "First
Row has Column Names". I believe this is what you want.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

I'm exporting ( dts package) a query to a csv file, how do I get the
column names in the file.
I get the data but no column headings.
Thanks in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

simple DTS question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

simple DTS question - 12-12-2006 , 10:45 PM

Re: simple DTS question - 12-13-2006 , 06:31 AM

Re: simple DTS question - 12-13-2006 , 04:38 PM