Home Forums SQL Server 2012 SQL 2012 - General SSIS Failure Workflow not getting triggered upon OLAP processing task failure RE: SSIS Failure Workflow not getting triggered upon OLAP processing task failure

  • March 28, 2017 at 12:15 pm

    #1935358

    Edding Jan - Tuesday, March 28, 2017 11:49 AM

    Ok, thanks Steve.  I will give that a try.  But I had thought Tim indicated that I was to set the Fail Parent for the OLAP Task only if the Error/Failure workflow attaches to the for loop: "If it attaches from the For Loop make sure Fail Parent is set in the properties of the OLAP task."   I didn't think this would apply to my situation since the Failure workflow is not attached to the For Loop.  Maybe I'm misunderstanding.

    Then the question is, what IS attached to the Failure workflow?   You have to be able to "bubble up" the failure until it reaches the necessary level.   This may mean that even the ForEach Loop Container may need this same property set so that it's parent will fail when it does, having already set the OLAP task FailParent property to True.   And if there are levels between the ForEach Loop Container and the Failure workflow, each of those levels may need to have this property set.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)