Can anyone send me a sample of the syntax to use in
activeXscript to have my data appended to my destination
instead of overwritten? My source is a table and my
destination is a .txt file.

Thanks in advance for your help. Sandra

In article <0b9401c39292$77cd7560$a001280a (AT) phx (DOT) gbl>, Sandra
<silvah (AT) wellsfargo (DOT) com> writes
The Text File provider does not support appending. Write it to a new
file and then merge the files. Quickest way to merge the files I find is
through DOS, copy file1.txt+file2.txt newfile.txt


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

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