i have master and child packages. i have setup xml config for all the packages how to make them run in any machine / folder. i need more info on keeping to xml files connected to package so that based on config the pacakge runsShanmugaRaj

Hi, Do these links help?; - Understanding Integration Services Package Configurations; - http://msdn.microsoft.com/en-us/library/cc895212.aspx Package Configurations; - http://msdn.microsoft.com/en-us/library/ms141682.aspx SSIS Package Configurations; - http://msdn.microsoft.com/en-us/library/ms141682(v=SQL.105).aspx In a typical scenario you store the server name, location of child SSIS packages, location of log files, etc in your xml config. A typical scenario where this approach is very useful is when promoting SSIS solutions from development to test to production. You can use parent package variables where the master package looks at the xml configuration, then the child packages refer to the parent package variables so only the master package directly looks at the XML configuration file. This can further simplify deployment. These configurations are exposed to the child packages as parent package variables meaning only the master package references the XML file. My faviourite way is to just have the XML configuration file storing the server name, the rest of the configurations I tend to store in a SQL Server table. This is because when the nature of the configurations change, e.g. the log files are moved to a new logical drive on the production server. I can implement these changes using a SQL statement which can be more effective than find / replace within an XML file. If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood