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

SSIS Snack: Passing Parent StartTime to the Child Package

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

Published Monday, January 25, 2010 8:00 AM 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



GK said:

Thanks for the post Andy !!

Any chane you could post something on childe to parent.


May 14, 2010 9:17 AM

Kranthi said:

Hi.. Is it possible to change the value of parent variable from the child package??

September 13, 2010 1:45 AM

andyleonard said:

Hi Kranthi,

  Yes, but it's not well-documented. The short answer: parent variables are available to the child package while running in the parent-child pattern. And, they are available ByRef, which means you can change the value of the variable from inside the child, and the new value is reflected in the parent.

  I discuss it in an article I wrote for SQL Server Standard magazine (you need to register for PASS to access but registration is free and relatively painless): SQL Server Integration Services Package Communication at Runtime (

:{> Andy

September 13, 2010 8:01 AM

Luis Figueroa said:

Very straight to the point explanation. Thanks!

December 15, 2010 2:24 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement