Home Forums Data Warehousing Integration Services How can I run the same package, at the same time with different configs RE: How can I run the same package, at the same time with different configs

  • The problem with running them parallel is that I the code I would have to create to solve the problem with creating a signal file when they all are complete. I am sure with some more experience and time I could find a better way.

    I've decided to run them serially in one job per frequency

    Frequency Daily - pkg1_Step1, pkg2_Step2, pkg3_Final

    Frequency Monthly - pkg1_Step1, pkg2_Step2, pkg3_Step3, pkg4_Final

    The Final packages have the config variable cfg_RunPostOps = true and the PostOps step will copy the signalyyymmdd.done file to the outbound folder.

    I'm still open to suggestions. Is there a way to have a master call a child and pass in the configuration file for the child to use. I don't see a configuration option for the package that can be set with an expression, only the Connection property.