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