By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

DTS Package - Append Results to Text File

P: n/a
I have created a DTS package which transfers data from a SQL 2000
server table to a text file. Each time the package is executed the
data in the text file is replace with the new data from the current
execution of the package. Can DTS append new text to a text file and
not replace it each time the package executes. Is there an option or
seeting for this? I havent seen one. Can anyone help me out on this.
Thank you,

Brett

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"bdwgarth" <bw****@lbrspec.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I have created a DTS package which transfers data from a SQL 2000
server table to a text file. Each time the package is executed the
data in the text file is replace with the new data from the current
execution of the package. Can DTS append new text to a text file and
not replace it each time the package executes. Is there an option or
seeting for this? I havent seen one. Can anyone help me out on this.
Thank you,

Brett


http://mssql.meetholland.com/message/162162.aspx

Simon
Jul 23 '05 #2

P: n/a
I doubt it will let you handle merging file text thru DTS. Anyone
correct me if I am wrong..!

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.