Hi, I had three different sources, using ssis package i loaded three different data into three different databases. Now I create a master package where all three child package will be executed through execute package component. My problem is how to create a configuration file & which properties i need to select to change the source or destination databases. Can any one help in finding out different was of configuration. Thanks Shanu

Take a look at the article I wrote here: http://biresort.net/blogs/pedrocgd/archive/2009/05/13/stepbystep-ssis-using-package-configurations.aspx Download the attached file in the link above with the entire document and SSIS Project. Helped? Regards, PedroVisit My Business Intelligence Blog - If your question is answered, please mark as answered.

thank, but can tell me briefly about the configurations. In my master package i call three child packages.. in that master package i gave all variables in child packages. If i change the destination database in configuration file, the table is not exists in that database so it is failing.

If i change the destination database in configuration file, the table is not exists in that database so it is failing. yes so it will fail, sorry but I did not get what you mean by the above statement.

configure connection manager properties in global.config file. configure all the packages to use config file . use windows environment variable to store global.config file location and set up package to read settings from environment variable (Go to SSIS menu and click on package configuration) use package variables to store table name (including DB prefix) and use "table name or view name variable" in data flow destinationhttp://sqlworkday.blogspot.com/