batch file to execute 5 SSIS packages

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  December 27, 2010 at 3:18 pm

  #232390

  Hi all..

  How can I create a batch file to execute 5 different SSIS packages in an order specified by me.

  I need to pass two variables during runtime which may change for every run...

  any help on this

  thanks

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• willtwc

  Ten Centuries

  Points: 1099

  More actions

  December 27, 2010 at 3:36 pm

  #1266591

  use DTExec. You can pass variables into the packages.