hlevine5
asked on
DTS package to append query results in a text file
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.