Calling a Data Pump task from DTS?

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!

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!
>

Thanks so much!  I'll give it a try.

noelle.bond@gmail.com wrote:

> Thanks so much!  I'll give it a try.
>

Just be forewarned, the DTS designer has a big disconnect between what
it shows you as the name of a DTS step and what actually needs to be
used in your VBScript code to refer to it as...