Hi, I am using sql server 2008 r2. i have developed 2 packages. first i had created xml config file in first package. in this 3 oledb conections is there. seccond package also i am using same config file. but in this package i am using only 2 oledb connection. when i had run that job first package was sucessful completed. but second package was showing congif file related error. error: third connection is not there in second package. when ever i had third connevtion in second package it is working fine. can you tell me how to solve above error.

Hi Subba Reddy, You cannot use same config file for both the packages. Just try creating parent package variable configuration in the second package and configure the two connection string which you want to use for second package. call the second package from first package.

Hi Subba Reddy msbi, It seems like in your second package there is no such variable defined who can hold the value of the third oledb connection (configuration value). As you are using the same XML configuration file, whichever the package will use this file will get 3 veriables. what you can do is, just create one more variable in your second package just like your first package, where this variable should hold the value of third variable from XML config file. FYI Logic: When you have configurations in your SSIS package and whenever you open the SSIS package, it will read the configuration file (in your case XML) and overwrite those values into your SSIS' local variables. My recommendation: 1. Have a master SSIS package which will connect to XML configuration file and read these 3 configuration values (3 oledb connection). 2. Call your SSIS package 1 from Master SSIS pacakge using Execute Package Task. 3. In your SSIS Package 1, use parent package configuration to read 3 variable values. 4. Call your SSIS package 2 from Master SSIS pacakge using Execute Package Task. 5. In your SSIS pacakge 2, use parent package configuration to read 2 variable values. Check out my article on configuring the SSIS package here: http://www.bigator.com/2012/01/27/how-do-i-configure-my-ssis-package-2/ Thanks, Khilit http://www.bigator.com

is there some specific need to have single configuration file for both the packages? when you choose single file, then at runtime dtexec.exe will load the same file and overwrite the local variables stored in that config file for both the package. depending on the operations, maybe it would be nice to have two separate config files for both the packages. regards joon