Hi,

I am using the wonderful DTS Bulk Export Task
(www.sqldts.com/default.aspx?237)

How do I export the column header (names of columns) into the first row
in the output CSV file?

The views that I export from SQL have different structures, so I can't
use a constant format file.

Any help is appreciated!

thanks,
vinod

Are you looking for support for a product you downloaded from the SQLDTS
webpage?

--
Simon Worth


<vchakravarthy (AT) datalabusa (DOT) com> wrote

Yes, but I am open to other possible solutions too. Thanks.

gotcha.
In a DTS when you define your text file output, you can specify "First row
has column names".

--
Simon Worth


<vchakravarthy (AT) datalabusa (DOT) com> wrote

Thanks.

Would you happen to know if there is a similar option or way to do
accomplish this using the Bulk Export Task from SQLDTS.com
(www.sqldts.com/default.aspx?23Â*7) ??


"Simon Worth" wrote:

I've never actuallly used that tool before.

--
Simon Worth


"vinod" <vinod (AT) discussions (DOT) microsoft.com> wrote

In message <1110299250.556379.23050 (AT) f14g2000cwb (DOT) googlegroups.com>,
vchakravarthy (AT) datalabusa (DOT) com writes
Simple answer is that task does not support that option.

As Simon suggests, it can be done with the DTS text file connection and
the DataPump, but that is not as flexible as you need to define the
DataPump up front with the structures.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hi Darren,
I've tried your emailaddress listed on sqldts.com but doesn't seem to work.
I too have a question regarding the bulk export task. Is it possible to
have:
1. Comma seperated, double quote text qualifer and first row contains field
names.
2. Fixed field, file type, ANSI. Row delimiter: {CR}{LF}

thanks Tom

--
Message posted via http://www.sqlmonster.com

"Tom de Koning via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

1 - CSV and text qualifiers can be done through a format file. Format files
are just like those used by BCP or BULK INSERT. Column names cannot be done.

2 - Yep, again format files

The mail address on the site deliberatly has an additional spam filter in,
as stated on the site, you need to remove it.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com