|
Home > Archive > Microsoft SQL Server forum > October 2005 > Calling a Data Pump task from DTS?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calling a Data Pump task from DTS?
|
|
| noelle.bond@gmail.com 2005-09-30, 8:24 pm |
| 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!
| |
| John Bell 2005-09-30, 8:24 pm |
| 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!
>
| |
| noelle.bond@gmail.com 2005-10-27, 9:23 am |
| Thanks so much! I'll give it a try.
| |
| corey lawson 2005-10-27, 9:25 am |
| 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...
|
|
|
|
|