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

  • I think I will go down the road of one SQL JOB with 4 steps. I have 1 step that needs to run on a certain day of the month, so I'll put a variable int he XML config to hold that day and then check it in the first step of the process. I'll also put another variable in the config "cfg_RunPostOps" and I will set that to true for the 4th package. In the previous packages I'll keep appending the row counts to a text file and then in my "PostOps" sequence container I'll move the file to the outgoing folder when I see that cfg_RunPostOps variable set to True.

    I don't know if SSIS 2012 has it, but it would be nice if that when you add a package to a Master package it would expose its variables to be set. Then I could run all three at once, point them all to step 4.

    Thanks for the help,

    Phil