|
|
Posted by noelle.bond on 10/01/05 00:01
I have a vbscript to read all files from a directory and, if the file
is valid, I would like my DTS to process it. I tried using the
vbscript as an ActiveX workflow script in the DTS, but it does not
execute the data pump until it has completed looping through all the
files, so only the last file read is sucked into the database
(utilizing a global variable as the filename). Is there a way to
execute the data pump task from within the activex script? I can't
seem to find any documentation about executing a DTS task.
Basically, the workflow I want is:
1)Read files from directory (the number and names may change each
time). (done with vbs)
2)For each file, send it through the transformation into the database.
3)When the information is in the database, append a date to the file
and move it to the archive folder. (done with vbs)
If I am going about this the wrong way and you see something that is
not obvious to me, please let me know.
Thanks in advance!
Navigation:
[Reply to this message]
|