Hello,

I'm trying to set up a scheduled DTS task to export a table of mine. I
would like this export to append to a comma separated text file. That
way, if i set up the backup to occur daily, i can move the file each
day and have a daily set of the entries into that db table.

I see the "Append rows to destination table" option, however, it is
always disabled for me. I've tried both the "Copy tables" and the
"Query" options to build up what is being exported. (ideally i'd be
able to do this with the query option).

Is it possible to export to a comma separated file and have it append?
(aka, get that option enabled)

Thanks

There isn't a direct way to append. But you can create a
second file for the export and use a DOS copy command to
combine the two files -
copy FirstFile.txt+SecondFile.txt NewFile.txt

-Sue

On 15 Mar 2006 10:23:43 -0800, markbouchard (AT) gmail (DOT) com wrote: