THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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 AndyLeonard.blog.

SSIS Snack: Passing Parent StartTime to the Child Package

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

http://andyleonard.blog/2010/01/25/ssis-snack-passing-parent-starttime-to-the-child-package/

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

Comments

 

GK said:

Thanks for the post Andy !!

Any chane you could post something on childe to parent.

Cheers

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 (http://www.sqlpass.org/LinkClick.aspx?fileticket=-u_hxRAQSuk%3d&tabid=236&mid=1477).

:{> 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

(required) 
(required) 
Submit

This Blog

Syndication

News

My Latest Book:

Community Awards



Friend of Red Gate

Contact Me

Archives

Privacy Statement