I have a DTS package that takes the results of a query and writes them to a text file. The problem I have is that each time the package runs, it overwrites the text file; I would like it to append the new results to the text file.
The current DTS package has 3 elements, the connection to my server, a data transform task, and the connection to the destination text file. I see no properties of the transformation that allow me to select an 'append' option'.
Thanks for any help.