December 27, 2011 at 8:44 am
I'm using parent/child packages to perform my task. Parent package is the master package which gets the connection string from SQL Server, via indirect configurations using environment variables. All the child package will get connection string from sql server. Everything works fine.
Now my question is whether we can inherit the connection string from parent package variable and use this in child package.
we have more than 20 child packages.
Which will be the best approach.
Thanks for your help
December 27, 2011 at 9:15 am
Do the tables / etc change with the different connection strings, or is it just that the parent will be deciding which amongst a series of replicated servers is being used by the child?
If the former, then no, you probably can't do this, since the child package has to work with the same set of database tables. Short of setting up some sort of scripted child tasks where based on the input connection you change the flows, which could get ugly.
If the latter, then yeah you should be able to. Just create your child package with a specific connection string, then change your connection string property to an expression based off a variable that you get from the parent.
December 27, 2011 at 6:20 pm
You can pass information from parent packages to child packages. Go to SSIS and click on Package configurations then click the enable package configurations and click Add. Set the configuration = Parent package variable and type in the name of the variable in the parent package.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply