Hi I have some 10 ssis 2005 packages. source Db and destination Db for these packages are common. I am calling these child packages in a master package. I am using only one XML config file for this master. Here by using the parent package variable(in Master package) i am setting the values like DB connection settings etc.. in the child packages.By this way i avoided the config files for child packages. Its working fine. Now the issue is that user wants to execute the individual package also(not from master) and user doesn't want to use more config files. Please suggest me the best approach to have one config file for all the ssis packages. Thanks

Thanks for your reply Todd. I am reusing the existing XML config file in the packages but when i build the solution it is giving the error.

Did you set SuppressConfigurationWarnings to true for the packages. I think this could avoid buiding errors.

I set the SuppressConfigurationWarnings to true, but still getting the build errors. Error description:- System.ApplicationException: Could not copy file "C:\Documents and Settings\ABCD\My Documents\Visual Studio 2005\Projects\Integration Services Project1\Integration Services Project1\Master.dtsConfig" to the deployment utility output directory "C:\Documents and Settings\ABCD\My Documents\Visual Studio 2005\Projects\Integration Services Project1\Integration Services Project1\bin\Deployment". ---> System.IO.IOException: The file 'C:\Documents and Settings\c119455\My Documents\Visual Studio 2005\Projects\Integration Services Project1\Integration Services Project1\bin\Deployment\Master.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow)

Hi, Open your child packages in BIDS and go to SSIS->PackageConfigurations Add the same configuration file and use reuse existing it should work Thanks, Shobhit

Hi Mr. One, How do you acommplish your Connections and config file. Can you send me more info. Thanks.