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

  • I'm not sure I fully understand your question, but here's nonetheless a first attempt at answering it.

    You are right that you will need an execute package task to run the child package from its parent.

    In the child package, you should use package configurations. The important thing to know here is that package configurations can set a variable or property multiple times where the last setting wins. If a configuration fails (either because the variable or property it is trying to set does not exist or - in the case of a configuration of type "Parent Package Variable" - the parent package variable does not exist), this will give a warning but this will not hinder your package executing.

    If the configurations are the same for both packages, you could use the same configuration file (or same configuration filter in case your configurations are stored in a database) for the child and the parent package.

    If the configurations are different, you have several options:

    - use different configuration files (one for the parent and one for the child)

    - use the parent configuration file in both packages, but then overwrite some values with settings specific to the child package using a second configuration file that is specific to the child and that is read after the first one

    If the settings in the child package are different depending on whether it is executed on its own or called from the parent package, you would do as above, but add a final configuration where you overwrite some values using Parent Package Variables. If the child package is executed on its own, the parent variables are not defined and this step will have no effect (you will see a warning though).

    PS: You can turn these warnings off, but you are discouraged to do this in a production environment.

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]