Hi, I have a DTS which has a connection, 3 destination text files and a
Process execution job which runs a simple batch file to concatenate this
3 files into a 4th text file "Endeud.txt". I added an activeX command
Job to input a date which is saved in a global variable. I need to add
this date at the end of the Endeud.txt file (The date would
be the last line of Endeud.txt. How can I do this?




*** Sent via Developersdex http://www.developersdex.com ***

Best way would be to do this in an Active Script task after the "Concat"
task. You can use the FileSystemObject to do this.

Allan

"Marcela Cure" <m_cure (AT) hotmail (DOT) com> wrote

How can I concatenate this varible using the FSO?



*** Sent via Developersdex http://www.developersdex.com ***

You do not concatenate it per se, after you have finished doing your
export you can write what is essentially the footer to the text file
using FSO in an Active Script task.

Something similar to

http://msdn.microsoft.com/library/de...filesystem.asp


Allan


"Marcela Cure" <m_cure (AT) hotmail (DOT) com> wrote