Post reply

Failure path processing of multiple steps

  • 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?

  • 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

  • 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.

  • July 3, 2010 at 9:12 am

    #1188522

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

    RB

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply