Post reply

Pipeline Failure Route not working

  • April 12, 2024 at 2:10 pm

    #4410571

    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 7 months, 1 week ago by  rjdineen.

  • April 12, 2024 at 3:30 pm

    #4410584

    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

  • April 15, 2024 at 12:02 pm

    #4411408

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

  • April 15, 2024 at 12:03 pm

    #4411409

    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