Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

SSIS: But it used to work in DTS (3) - Passing a parameter from a parent package to a child package

Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.


Passing a parameter from a parent package to a child package

In DTS, packages could execute other packages by use of the Execute Package Task. Values could be passed between these packages using the Inner Variables and Outer Variables tab of the Execute Package Task.

In SSIS, a package can also execute other packages just as one could in DTS. Inner/Outer variables have disappeared and in their place we have parent package configurations. These allow us the capability of taking any value from a calling (i.e. parent) package and setting a property in the called (child) package to have that value. That property could, and often will be, the Value property of a variable and hence we can set variables in a called package to the value of something in the calling package. Note that the altered property could be a property of any of any container in the control-flow, hence giving us much more flexibility than in DTS.

To learn more about passing variables between packages go here.

 

Published Thursday, June 29, 2006 1:14 PM by jamie.thomson

Comments

 

SSIS Junkie said:

I've said on numerous occasions, in slightly different ways, that making the move from DTS to SSIS

December 21, 2006 7:34 PM
 

SSIS Junkie said:

I've said on numerous occasions, in slightly different ways, that making the move from DTS to SSIS

January 15, 2007 10:36 PM
 

SSIS Junkie said:

Someone recently asked me if it was possible to dynamically set the location of a checkpoint file. Happily

November 15, 2007 8:46 PM
 

Nagarajan said:

Hi,

I like your blogs very much.

I gathered lot of information from your blogs.

I have a question for you.

Is it possible to access System::ErrorDescription of a parent package directly from within a child package

March 21, 2008 10:17 AM
 

jamie.thomson said:

Nagarajan,

No, its not possible I'm afraid. There are a few reasons but the main one being that each instance of that variable is scoped to an eventhandler.

Thinking about it, I can't understand why you would want to do this.

-Jamie

March 21, 2008 2:04 PM
New Comments to this post are disabled

This Blog

Syndication

Powered by Community Server (Personal Edition), by Telligent Systems