I need a Package that loops through a recordset containing tablenames
that have to be transferred to another server.

I've so far created a task that returns the table names to a
globalvariable, a task that loops through the variable setting a
"createtable if not exists.." on a SQLTask and then set the datapump
source and destination tablenames to be transferred. My problem comes
when I need to execute the ExeSQl task and datapump task within the
ActiveX script loop task!

Can anyone tell me how to execute a task within task (ActiveX script)?

Many Thanks in advance

You can execute a package from a task -
Execute a package from a package
(http://www.sqldts.com/default.aspx?215)

You could even call another tasks related step Execute method.

The best way I think is to take the loop out into the package itself, using
workflow, not just a single task. This way you can loop around as many task
as you want.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)


--
Darren Green
http://www.sqldts.com


"Barry" <barryjarcher (AT) hotmail (DOT) com> wrote