How to pass a variable from child package to parent package.

Who is online?  0 guests and 1 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » How to pass a variable from child package to parent package.

How to pass a variable from child package to parent package.

Topic RSS Feed

Posts under the topic: How to pass a variable from child package to parent package.

Posted: 12/6/2011

Jedi Youngling 74  points  Jedi Youngling
  • Joined on: 11/28/2011
  • Posts: 27

Hello All,

I am having a package which has one execute sql task, for each loop enumerator and inside for each enumerator I have a execute package task.In the execute package task I have a child package which has a variable that I need to pass to parent package. How should I do that?. Any help is much appreciated.

Thanks


Posted: 12/6/2011

Jedi Knight 1516  points  Jedi Knight
  • Joined on: 1/3/2010
  • Posts: 266

sqlkala,

dts enables you to pass variable from parent package into child package. Take a look into http://www.sqlshare.com/SSISVariablesinParentChildPackagesandJobs_809.aspx

The opposite, child to parent, that will have much work to do, but we can figure out one way to do it. Let me know what you really need.


Page 1 of 1 (3 items)