April 12, 2024 at 2:10 pm
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. )
Kind Regards Rob
April 12, 2024 at 3:30 pm
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
Looks like i can use an if condition, this works quiet well.
April 15, 2024 at 12:03 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy