DTS Package - Append Results to Text File

[bdwgarth]

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

[Simon Hayes]

Re: DTS Package - Append Results to Text File


"bdwgarth" <bwalke@lbrspec .com> wrote in message
news:1105716432 .160263.235590@ c13g2000cwb.goo glegroups.com.. .[color=blue]
>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
>[/color]

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

Simon

[QueryBuilder]

Re: DTS Package - Append Results to Text File

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