CODEWITHSUNDEEP
azureazure-data-factory
user1941025
user1941025

Reputation: 611

Using If-Condition ADF V2

I have one Copy activity and two stored Proc Activity and i want to basically update the status of my pipeline as Failed in Logtable if any of these activities failed with error message details. Below is the flow of my pipeline

enter image description here

I wanted to use If-Condition activity and need help in setting the expression for it. For Copy activity i can use the below expression, but not sure about getting the status of stored Proc activity

@or(equals(activity('Copy Data Source1').output.executionDetails[0].status, 'Failed'), <expression to get the status of Stored Proc>)

If the above expression is true then i want to have one common stored proc activity that i will set in Add If True Activity to log the error details

Let me know if this possible.

Upvotes: 1

Views: 960

Answers (1)

Kamil Nowinski
Kamil Nowinski

Reputation: 545

I think you have overcomplicated this.
A much easier way to do that is to leverage a Failure path for required activities. Furthermore, SP would not be executed when Copy Data fails, therefore checking the status of execution of SP doesn't really make sense. My pipeline would look like this: enter image description here

Upvotes: 1

Related Questions