How to Assign Package Steps in SSIS
Posted on 2007-11-14
I am trying to migrate a DTS package done in SQL2000 to SSIS. The DTS package uses Dynamic Properties Task
It is apparent that SSIS does not support refering to the package within scripts at runtime.
I mean this one -- set pkg = DTSGlobalVariables.Parent
After the migration, i am getting errors on this step....
set pkg = DTSGlobalVariables.Parent
so going forward , i will not be able to set these ...
set stpEnterLoop = pkg.Steps("DTSStep_DTSDynamicPropertiesTask_1")
set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_3")
Any inputs on how this could be done using SSIS / VB.net