December 8, 2015 at 1:39 pm
I have a Parent Package called master.dtsx.
master.dtsx has a master.dtsconfig file which has a database connection string defined in it.
The master.dtsx has two execute package tasks excecuting ChildA.dtsx and ChildB.dtsx.
I need the same database connection string as in master.dtsx in the ChildA.dtsx and ChildB.dtsx.
What is the best way to do this. I would like to avoid any duplication.
Please Advice.
December 8, 2015 at 2:22 pm
Create a parameter in each of the child packages for the connection string. When the master package calls the child packages, have it pass the connection string to the parameter you created.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 8, 2015 at 4:27 pm
Will this work in SQL Server 2008? I searched and it seems like the parameter binding functionality is there only form 2012 and above.
December 9, 2015 at 7:38 am
sharepointfarmer (12/8/2015)
Will this work in SQL Server 2008? I searched and it seems like the parameter binding functionality is there only form 2012 and above.
SQL 2008 is a bit different. In SQL 2008 you set up a variable in the child packages and somehow configure those variable to get their value from the parent package. It's been a few years since I've done this and I forget the exact details regarding how you do this.
In SQL 2008, there's not passing of variable/parameters from parent to child. The child package gets the data from the parent package.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply