Thanks Russ!! I have 10 execute package task each is configuired to a individual packages stored in a a common place. I have a set the package configuration for to overirde the connections during runtime. The issue i am having here is the configuration file whatever i have now can tell me or i can override to tajke the packages from some other locations. But i need to know how will i override the configuration file what i have for the packages??? Actually i have a configuration file which has the connection string to connect to database, flatfiles etc. When i run from DTEXEC i will diretly execute the package which has the "EXCEUTE PACKAGE TASK" but i need to override the config file for the packages which are executed through "EXCEUTE PACKAGE TASK"..

Please refer yourself to how package configurations are applied: http://dougbert.com/blogs/dougbert/archive/2009/04/07/understand-how-ssis-package-configurations-are-applied.aspx When you use a parent-child approach there are some nuances.Arthur My Blog

The easiest way is to configure the connection string of the connection manager to use a variable (http://consultingblogs.emc.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx). Then you can populate the variable with a value from your database (http://www.sqlis.com/post/The-Execute-SQL-Task.aspx about half way down the page shows how to do that).Russel Loski, MCT

Hi, we use package configurations to override the connection parameters in the connection manager. To organize the different tasks we splittetd our load processes into multiple package files (dtsx) which are then put together into a workflow using "Execute Package Task" component. Now we need to override the connection manager for the package in runtime, With the option /CONFIGFILE it is possible to override the configuration file for the package that is called with via Execute package task using DTExec. Thanks, Vin_Ram