Hi,
I want use a DTS job to append to a text file at a given
interval. I can create the job OK but have not found a way
to sucessfully append the file, only drop and recreate the
file with the new data.

Any Help?
Mark

Yep that is the behaviour of the driver. Easiest way is to use the COPY
command

COPY a.txt + b.txt c.txt



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



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