I am having Parent package which calls the three diffrent child packages,I used the datasource as OLEDB connection, in which all packages uses the same datasource.How to pass connection string of datasource from parent package to child packages using dtexec.exe utility.
Make configuration file and use
dtexec /f "c:\pkgOne.dtsx" /conf "c:\pkgOneConfig.cfg"
It is an example where your SSIS package resides on FIle system and the next is the path of the configuration file, and if you want to pass the variables from Parent package to child Package then you can use "Parent package variable" property in Configuration file. Hope the link http://msdn.microsoft.com/en-us/library/ms162810.aspx will help you. Thanks.
