Friday, March 9, 2012

Run child package independently

Hi there

I have a parent package which execute a child package. But when the child package is run from the parent not all of the tools inside is executed. I have a variable "ExecuteStep" from the parent that gives information about which tools, that needs to be executed.

BUT

The child package should be able to run independently also. In this case all tools inside the package should execute.
This is however not possible because my variable "ExecuteStep" does not exist inside the package, it is inheritage from my parent.

If I create a variable with exactly the same name inside my child package, I can run the child independently, but when executed from the parent the value from the parent package is now overwritten by the child variable.

How can I get around this problem?

bjarneThe solution was just in front of me all the time.

As "Package Configuration" I was using the XML file I had generated with the Parent variables.

Instead I should have been using "Parent package variable", this way all works fine.

I found it with a help from Kirk Haselden's blog

http://sqljunkies.com/WebLog/knight_reign/comments/5366.aspx

Bjarne

No comments:

Post a Comment