I need to append multiple text files into a single text
file.
Can I use DTS do this? How to do this kind task by DTS?
Thanks in advance.

-Don

In article <062101c3a666$5a958810$a001280a (AT) phx (DOT) gbl>, Don Walter
<DW_msg (AT) Yahoo (DOT) com> writes

DTS cannot do this directly. The simplest way I find to do this is via
the DOS copy command, e.g.

copy file1.txt+file2.txt+file3.txt Results.txt


This could be wrapped in a batch file and called via the Exec Proc
Task.

You could use scripting to read and write the files to one output, but
this would be slower.


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

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