By Header I presume you mean in a text file?

Forget using the phases. It is often alluded to but damned if I can get it
to work.

What I do is

Export a "Header" Text File
Export the "Data" Text File
Use COPY Header.txt + Data.txt AllTogether.txt




--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


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

refering to the ability to do this, but no examples.

David,

That is how I do it as well. Although I've noticed that the using COPY
for file concatanition seens to insert a 1A character at the end of the
file. It has never caused a problem for me though.

The SAMS book "Microsoft SQL Server 2000 DTS on page 235 specifically
recommends using the Pre Source phase to write a header, but gives no
advice on actually implementing it. Which is probably based on a quote
in the books online, which also recommends using the pre-source phase
for headers without any implementation details.

Good luck,
Wes

Allan Mitchell wrote: