Home Forums Data Warehousing Integration Services Run a child package with its own configuration file from a parent SSIS package RE: Run a child package with its own configuration file from a parent SSIS package

  • February 22, 2010 at 6:19 am

    #1122885

    wschampheleer (2/22/2010)

    You can use package configurations in both the parent and the child package independently. The configurations for the child package should be defined in that package, not in the parent package or through the execute package task (which is indeed not possible).

    Sorry, I wasn't being clear I think. My current scenario is this:

    I have a package which uses a particular configuration file. This has been running independently as two separate sql agent job for a number of months now. There are two separate jobs as one uses the original configuration file as set up in BIDS, and the other uses another file with different values.

    I now have another package (the parent) which, as part of its run, needs to run the above package (the child).

    I'm currently in development of the parent, but it's highly likely I will have other variables that I need to add to the parent package's configuration file.

    Are you saying that, if I wanted the child package to run with different values to those in the child's original package configuration file setup in BIDS, then I need to add the same variable names in to my parent package as in my child configuration file and these will filter down in to the child when it runs as part of the parent?