DTS ExecutePackageTask
Dear All,
I'm trying to execute ExecutePackageTask within a package in a loop.
I need to call same ExecutePackageTask a number of times passing any time a different parameters. I'm trying to reset the parameters within ActiveX object, where on Success from ActiveX I go to ExecutePackageTask, then on Success from ExecutePackageTask I go back to ActiveX.
This schema does not work. I can not even start the process.
Does anyone has any experience in building this sort of loops?
(Or, may be, how can I organise a loop to run a task for a number of times within a package?)
Any your help or comments will be very appreciated.
Anthony Crouch
|
