Failure path processing of multiple steps

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  July 2, 2010 at 11:43 am

  #140896

  Hi, I am working on the failure path of an SSIS package that processes daily flat files for inclusion in a database.

  I would like my failure path to take effect if any of the steps fail. Do I need to connect a red failure line to each of the steps as a "logical or" or can I simply specify to go to the fail path if any one of a group of steps fail?

• PaVeRa22

  SSCommitted

  Points: 1965

  More actions

  July 2, 2010 at 1:32 pm

  #1188402

  PHXHoward,

  you can write Event Handlers, to do so...

  Select Event Handler Tab in BIDS

  Executable: from drop down select your package Name ( means defining event handler at package level)

  Event Handler: Onerror (Default, you can select other events also)

  Define all failure steps here, All these steps/tasks will be executed if any task of your package fails

  Very interesting right....

  RB

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  July 2, 2010 at 1:52 pm

  #1188417

  Thanks RB, it is very interesting. I'll give it a try. Event handlers and logging are things I've been wanting to learn about.

• PaVeRa22

  SSCommitted

  Points: 1965

  More actions

  July 3, 2010 at 9:12 am

  #1188522

  Please let us know if you need further help/info....:-)

  RB