Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Appending to a text file via DTS

    DTS wizard is not allowing me to append the data to a text file. Every time I run DTS and choose the destination to be this text file (say A.txt), it overwrites the data. I have a table whose data I am dumping to a text file. I truncate the table, then get the data again into it and want to append it to the same text file. But I end up overwriting the text file with the new data.

    Kindly let me know where I am going wrong.

  2. #2
    Join Date
    Dec 2002
    I am having the same issue as well... I thought I remember seeing an option checkbox somewhere to do that... but I cant seem to find it.
    I doubt we are the only ones having to deal with this, so can someone please chime in with an answer or maybe a possible direction for us to follow? Thanks in advance....

    Online Gamers Guild

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts