I want to keep appending to an existing text file destination output
file everytime I run a DTS Package.

Unfortunately DTS keeps ovwerwriting what is in the file.

How do I append into a text file destination.

Thanks
Karen

Karen,
Would you like to try to use Excel Spreadsheet and save it as text file by
using ActiveXScript after the export?

Function Main()
' Launch Excel
Dim Xl
Dim sSourceFile
Dim sOutputFile


sSourceFile = DTSGlobalVariables("gSourceFile").Value
sOutputFile = DTSGlobalVariables("gOutputFile").Value
'MsgBox sSourceFile
'MsgBox sOutputFile

Set Xl = CreateObject("Excel.Application")

'Make it in-visible
Xl.Visible = False

'Open my execl file, and sheet
Xl.Workbooks.Open(sSourceFile)
Xl.Worksheets("YourWorkSheetName").Select

Xl.ActiveWorkbook.SaveAs sOutputFile,-4158,0
Xl.ActiveWorkbook.Close(0)
Xl.quit

Main = DTSTaskExecResult_Success
End Function

Hope this help
Ed


"karenmiddleol (AT) yahoo (DOT) com" wrote:

The text file destination doesn't support appending to files. Write a new
file then merge them together. Simple way is to use DOS copy, e.g.

copy file.txt+other.txt newfile.txt


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
<karenmiddleol (AT) yahoo (DOT) com> wrote

Hi Karen,

"Darren Green" wrote:
wanted

Helge