Hello all, I have one master package and two child packages .I want to change connection strings of connection managers of child packages.Is there a way that I can just create one master configuration file and change connection strings of child packages dynamically,instead of creating configuration file for child packages. Thanks for help..Masti

Yes, you can do so. What you need to do is to create a string variable in your master package - call it "MasterConnectionString". You need to create a configuration in your master package that populates MasterConnectionString's value property. Then add a property expression to your master package's connection manager, specifically, the connection string property - setting it to MasterConnectionString. In your child packages - called via Execute Package Tasks in the master package - need to have a string variable as well. Call that "ChildConnectionString". Set up an expression on the connection manager's connectionstring property just like you did in the master package, but use ChildConnectionString instead. Last, create a package configuration - but this time a Parent Package Configuration. Type in MasterConnectionString as the parent variable, and identify the value property of ChildConnectionString as the target property. Talk to me now on

Suggest you seeing Using Single Configuration file for all Packages http://sqlservermsbiblog.blogspot.com/2010/10/using-single-configuration-file-for-all.htmlArthur My Blog