Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to Assign Package Steps in SSIS

Posted on 2007-11-14
3
Medium Priority
?
544 Views
Last Modified: 2013-11-30
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
Comment
Question by:thomasbastian
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 20307951
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question