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

  • January 15, 2014 at 2:55 am

    #1680156

    Phillip.Putzback (1/14/2014)

    Unless I am misunderstanding where you are running dtext from. Is it possible to have the sql job run dtexec to call the master and then the master call dtext on each package passing in cfg_ExtractType via the /SET switch?

    Yes, I am talking about 3 SQL jobs (not 3 job steps because you want the execution to run in parallel) that call the master package using the /SET option to specify the value for the cfg_ExtractType variable - obviously a different value per job.