Executing SSIS Packages Using Bat file

• rams.kola

  Mr or Mrs. 500

  Points: 563

  More actions

  April 20, 2012 at 4:18 am

  #256758

  Hi,

  I have one bat file, in that bat file am configuring 18 SSIS Packages. I have executed the bat file, when any package fails it will stop the execution of bat file or it will go the next package execution??

  Regards,

  Ram

• Koen Verbeeck

  SSC Guru

  Points: 259135

  More actions

  April 20, 2012 at 6:59 am

  #1476598

  I believe it will stop.

  Is it not an option to execute your packages within a SQL Server Agent job?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP