[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

How to Assign Package Steps in SSIS

Hello ,
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
from SSIS.....

Thank you

Thomas
0
thomasbastian
Asked:
thomasbastian
1 Solution
 
Eugene ZCommented:
make sure fresh sql server 2005 service pack was installed

read:
Get a reference, within a script, to the package using DTSGlobalVariables.Parent
(http://blogs.conchango.com/jamiethomson/archive/2006/07/26/4278.aspx)

Modifing a Package in script
(http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx)

-Jamie
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now