Link to home
Start Free TrialLog in
Avatar of hlevine5
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.
ASKER CERTIFIED SOLUTION
Avatar of Brendt Hess
Brendt Hess
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial