hi all, i would like to add two Execute Package tasks, which invoke one identical package but with different package configurations. how can i achieve this. ThanksAndrew BI, Data Mining, Analytical CRM

Hi Andrew, You can do that by using the standard Execute Process Task to execute the package using DTEXEC and providing different /CONF parameter for the same package. Check DTEXEC documentation here for more information.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi CozyRoc, Thanks for ur helpful reply. while there is a limitation that "However, you cannot use the /ConfigFile option to replace configured values that you also specified at design time. " thanksAndrew BI, Data Mining, Analytical CRM

In my opinion you may need to have a parent package variable passed into the child package. This Parent variable will drive the logic. This approach has been described here http://msdn.microsoft.com/en-us/library/cc671625.aspx You may want to skip to section 'Parent Package Variables Approach' Arthur My Blog