Hi, I am using one configuration file i.e. MyConfig.dtsConfig This is a single file which is used by two ssis packages. Now I have created the third ssis package which is using more variables and connections than the first two ssis packages. So the new config file has more expressions into it. I would like all three packages to use this last created config file but because packages 1 and 2 do not have the extra connections and expressions that the package 3 is using, it seems that the packages 1 and 2 do not like to use this new config file. Question: Based on the scenario above, can I use just this one config file for all the packages? Please remember that packages 1 and 2 have less expressioins than package 3. Hope you follow what I am asking here. If not please ask and I will elaborate further. Thanks

Yes you can use one config file for all three packages. Only thing is do not declare other variables in package1 and package2.

If your third package has more Variables and Configurations to configure and you want use the config for all packages you have three selections 1. configure only variables and the connectuon managers with these variables, add the variables to the first two packeges even if you don't need them 2. use a second config file for the third package with only the additional values 3. use SQL configuration and configure only the connection to this configuration in all your packages

to have a centralize connectingString repository see: http://randypaulo.wordpress.com/2011/12/02/ssis-centralize-connection-repository/Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File

How is this done. I tried it but there was an error message.

Hi arkiboys, Multiple packages can use the same XML configuration file. Please refer to the following similar threads: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1c13f4dd-d822-4420-90f6-ecafbe53e439/ http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/dd92eb4b-404f-4618-a09c-56e16d66561f If you have any question, please feel free to ask. Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contacttnmff@microsoft.com.

There is now an utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS: http://ssisconfigeditor.codeplex.com/