THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Accessing Parent Package Variables In Child Packages... Without Configurations

This blog has moved! You can find this content at the following new location:

Published Sunday, September 30, 2007 7:57 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Anoop Verma said:

Although this is a very old post, I would like to share my understanding on this statement - "The child updated it – kind of like ByRef arguments in VB."

To me it seems more akin to scope-declaration. If you declare a variable with the same name as in the parent (in this case MyParentVar), the Child package will find this local variable. If you do not declare it, then it goes to the next level up - which is the parent package. You can also think of it as a "global variable" within the universe of the package.

For ByRef, the arguments still need to be explicitly passed between the caller and the called methods, where as with the scoping, the access is implicitly available.

January 31, 2013 6:44 PM

andyleonard said:

Hi Anoop,

  You are correct, and your explanation closely resembles my current understanding of the process. Thank you for your feedback.


January 31, 2013 8:38 PM

mario amatucci said:

This is one big difference between Execute Task and Execute process invoking dtexec, loads of guys think they are the almost same, but the true is the master and child package are sharing the same stack, kind of. It would be great to have a technical doc from Microsoft about the implementation of Master/Child package.

January 10, 2014 11:44 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement