Append Data

[ascheper]

Through DTS I created a package to export some data to a text file. Is there a way to append the data to the file instead of overwriting the file?

 

[tlbroadbent]

The text file export does not support appending data. You can export to a new file and then append the new file to the old file with a DOS copy statement. If you are creating a DTS package you can add an Execute Process Task to the package to execute the copy statement.

copy OldFile.txt + NewFile.txt OldFile.txt
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.