|
|
Posted by Simon Hayes on 09/08/05 02:38
"Marce" <m_cure@hotmail.com> wrote in message
news:1126109742.578214.98180@g49g2000cwa.googlegroups.com...
> 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?
>
The best way is probably an ActiveX step which opens the file and appends
the date. You could use VBScript and the Scripting.FileSystemObject object,
for example. Or if you want to use a process execution step, then this shell
command would work:
echo 20050908 >> Endeud.txt
But you would still need to set the ProcessCommandLine attribute of the task
based on the global variable, so it would probably be easier to just do the
whole thing in ActiveX.
Simon
Navigation:
[Reply to this message]
|