Pipeline Failure Route not working

  • Hi there,

    I have a couple of Stored Proc tasks, that fire off after each other.

    Also each on stored proc task with a failure to the same set variable task, but the failure is not working.

    am i doing something obviously silly here?  ( in the below image i would expect the first set variable to fire off, follow by the rest. )


    Pipeline Failure NOT WORKING


    Kind Regards Rob

    • This topic was modified 1 month ago by  rjdineen.
  • I have not used ADF, but I did a quick search and it sounds like the error tasks will only execute if both of the preceding tasks fail. In SSIS you can set precedence constraints to AND/OR  with OR identified by dotted lines. It sounds like ADF doesn't make it that easy.

    The links I read could well be out of date, but this one has a suggested solution. It doesn't make much sense to me as I am not familiar with ADF. https://learn.microsoft.com/en-us/answers/questions/208812/adf-run-an-activity-if-any-one-of-a-set-of-activit

  • Looks like i can use an if condition, this works quiet well.

  • Thank you for your help

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

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