I am looking for information on how to use DTS to export a
text file and to have it append to this text file when the
DTS package is run in the future. Any information is
greatly appreciated. Thank you.

In article <007f01c3a49a$eafca2d0$a601280a (AT) phx (DOT) gbl>, Gina
<anonymous (AT) discussions (DOT) microsoft.com> writes
I'm afraid the text file provider does not support this behaviour.

The solution I use is to create the two files and then use a DOS copy
command to concatenate the two files, e.g.

copy FileA.txt+FileB.txt Results.txt

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

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

Sometimes I don't get good results using the copy command to append two
files. In those situations I can sometimes get by with redirecting the
output of FileB.txt to append to FileA.txt. e.g. TYPE FileB.txt >>
FileA.txt


"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:ayhy1KKbIqq$Ew1H (AT) sqldts (DOT) com...