|
|
Posted by John Bell on 10/01/05 01:56
Hi
This may help:
http://www.sqldts.com/default.aspx?246
John
<noelle.bond@gmail.com> wrote in message
news:1128110995.716126.283160@g47g2000cwa.googlegroups.com...
>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]
|