SSIS Package Configuration - Issue with Parent Child Packages
I have a Master Package which calls a few other packages, the master package has a configuration file and each of the child packages have their own set of configuration files, everything was fine while it was being executed through BIDS. Now, when I am trying to execute it through DTEXEC, I am running into issues. Over here, I am only providing the location of configuration file for the master package. How can I pass the locations of the configuration file for the child packages.
July 1st, 2011 2:03am

Hi SriramYs, You can make sure all your child packages are connected to config files.If all child packages are already connected to config files then Master package should not fail. Please recheck the configuration file settings.It would be helpful if you provide me the excat error. Thanks, Vaibhav Please mark this as answer if it is helpful to you.
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 2:18am

Command line options are not passed from a parent package to a child package. So it is not possible to override the configuration locationon a child package by using a DTEXEC command line switch to override it on the parent. http://msdn.microsoft.com/en-us/library/cc671625.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
July 1st, 2011 2:19am

Best way is, create the folder structure as in DEV. And make shure, that the user who executes the packages has permissions on the folders. You can't set the Configuration Path for the child Packages from outside. On way: pass the path for the Child Package Configuration file from master Package as a first Configuration in the Childs. But than you can't execute these packages standalone, because they won't find their Configuration.
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 2:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics