Master Package configuration changes not affecting in Child packages

Question

Master Package configuration changes not affecting in Child packages

sumeshat

SSC Rookie

Points: 31
More actions
June 22, 2012 at 1:11 am

#150957

Hi
I have a master which is used for execution of all other child packages. I am using One xml configuration file for master and child packages data base connection. but changes in the configuration file is not afftecting the Child Package.
pease help

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Is everything between the package configurations named exactly the same? Do both packages expect their config files to be in the same path?

sumeshat SSC Rookie Points: 31 More actions · Answer 2

yes..Configuration name should be the same..

I am bit confused about the working of this..could u please explain...

ganeshnarim SSC Eights! Points: 834 More actions · Answer 3

Hi,

Use an environment variable to specify the XML file name and path

Set the XML file name and path as a command line parameter at runtime

Remember that any environment variable that you add while BIDS (or Visual Studio) is open will not show up in the environment variable list until you close the application and reopen it.

When you are working with an SSIS package in BIDS (or Visual Studio) , the package configuration is read when you open the package. Any changes made to the configuration will not be reflected until you close and reopen the SSIS package.

For more details please look at books online http://technet.microsoft.com/en-us/library/ms141682.aspx

Hope this helpful..

Thanks

Ganesh N

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

Are you using the same config files in the parent and child packages or just in the parent package and expecting it to "flow" down to the child?

CEWII

sumeshat SSC Rookie Points: 31 More actions · Answer 5

Hi

I am using the same config file for all the packages

thanks

Sumesh

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

In that case the names and scopes of the items being modified by the config file must all be the same otherwise it won't affect them. Also are the packages built with the config information or are you passing it at run time.

CEWII