DTS - Execute Data-pump Task

SQL 2K
Using Active X script , created the source SQL statement for data-pump task
and it worked.
Inside Active X script I am looping thru to change the source SQL
statements, how can I again execute this data-pump task.
When I look the source SQL in data-pump task it got changed , but data-pump
task executed only once.
So my question is, how to execute a data-pump task inside Active-X script '
Thx
DUWhat are you using to determine your new connections ?
Why do you need to reset this during the package?
You can easily loop to do this but you have to loop on something.
How are you calling the package ?
Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246)
How to loop through a global variable Rowset
(http://www.sqldts.com/Default.aspx?298)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"MS User" <sqlman@.sql.com> wrote in message
news:%233nQmIbnDHA.744@.tk2msftngp13.phx.gbl...
> SQL 2K
> Using Active X script , created the source SQL statement for data-pump
task
> and it worked.
> Inside Active X script I am looping thru to change the source SQL
> statements, how can I again execute this data-pump task.
> When I look the source SQL in data-pump task it got changed , but
data-pump
> task executed only once.
> So my question is, how to execute a data-pump task inside Active-X script
'
> Thx
> DU
>