Post reply

SSIS OnError Propagation

  • January 15, 2010 at 2:04 am

    #215630

    I have an SSIS flow that consists of the following components:

    Foreach(ADO Recordset)

    Sequence (Transaction Container)

    Script Task

    Web Service Task <--- Problem is here

    Etc.

    ...

    It's not uncommon, in our environment, that one or more of the web services accessed by this flow will be unavailble. When a service is unavailable, the Web Service Task encounters an error and fails.

    I am handling the OnError event for the Web Service Task, and logging the failure and its cause to the event log. I've set the following event Propagate flag values:

    Web Service Task -- OnError Propagate = true

    OnTaskFaile Propagage = false

    (I want the Web Service Task to report the error to the Sequence).

    Sequence -- OnError Propagate = false

    OnTaskFaile Propagate = false

    (I want the Sequence to STOP its current process).

    Foreach -- OnError Propagate = false

    -- OnTaskFail Propagate = false

    (I want the Foreach loop to process the next item).

    My thoughts in setting these values are that if the Web Service Task encounters an error, I'd like the further processing for the Sequence to stop, and return to the Foreach to process the next item. That is NOT happening. When the Web Service Task encounters an error, the entire flow fails (after the error is successfully logged by the OnError handler). It appears that the Web Service Task failure is being propagated all the way up the flow, regardless of the setting of the Propagate flags.

    Questions:

    1) What must I do to make this work the way I intend?

    2) Am I misunderstanding the way the Propagate flag works in SSIS?

    Thanks

    Dave Matlock

  • March 9, 2011 at 10:02 am

    #1296621

    Did you find out what was wrong?

Viewing 2 posts - 1 through 2 (of 2 total)

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