Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    20

    Question Unanswered: appending to the end of current file

    Hello all! I have a dts package exporting a text file. I would like for the dts job to append to the end of the file each time it is ran, rather than overwriting it. Is there a simple solution for this?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Darren Green suggested in earlier posts that :
    The text file provider does not support this. The simplest thing to do is to export to a new file, then use the DOS copy command to merge the files.

    This can be done with the Execute Process Task, and any dynamic filename stuff can be handled with an ActiveX Script Task to change the connection and the Exec Proc Task at the same time.

    copy FileOriginal.txt+FileNew.txt FileResult.txt


    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Posts
    20
    That is what I am currently doing. I was hoping for something within the dts package. Thanks for you help.

    val

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As suggested its not available using TEXT provider with DTS.
    May be this is also other way around, is to export to an excel sheet and save that as text file.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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