Adding a header row to DTS Destination file

#1

Is it possible to add a header column to a DTS Destination
file? I am able to output the row by row transformations,
but what a bout adding a one time header row to the out
put?

Tahnks for the help!
Stever

#2

Hi

This will depend on exacty what you are doing.

You could create a template file that is copied to the destination, data can
then be appended to the file.

You could use a SQL query data source that uses a Union to output the header
as the first row.

You could write it into an activeX script task......

John

"Stever" <spgblair (AT) blair (DOT) com> wrote

Quote:

Is it possible to add a header column to a DTS Destination
file? I am able to output the row by row transformations,
but what a bout adding a one time header row to the out
put?

Tahnks for the help!
Stever

#3

In article <3f5cc7ac$0$259$ed9e5944 (AT) reading (DOT) news.pipex.net>, John Bell
<jbellnewsposts (AT) hotmail (DOT) com> writes

Quote:

Hi

This will depend on exacty what you are doing.

You could create a template file that is copied to the destination, data can
then be appended to the file.

You could use a SQL query data source that uses a Union to output the header
as the first row.

You could write it into an activeX script task......

John

...

or write two files and merge them using DOS copy, e.g.

copy file1.txt+file2.txt outputfile.txt

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

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

Adding a header row to DTS Destination file

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

Adding a header row to DTS Destination file - 09-08-2003 , 10:04 AM

Re: Adding a header row to DTS Destination file - 09-08-2003 , 01:20 PM

Re: Adding a header row to DTS Destination file - 09-09-2003 , 01:56 PM