Forum Discussion

Matt_Symes's avatar
Matt_Symes
Copper Contributor
Oct 22, 2021

How do I get a Stored Procedure activity in ADF to complete with Failure status?

I need to compare 2 values (a row count and an expected row count) and fail my pipeline if they differ. (Basically it's some validation that we extracted all the data we intended to because we have to use paginated API calls to pull out data.)

 

I'm already inside a Switch statement so I don't have access to IF activity (argh! so frustrating!) - so my thinking was to write a Stored procedure that compares 2 values and does a RAISERROR if they are different. However even though the stored procedure executes the activity completes with Success status.

 

Any thoughts on how I can make the stored procedure activity complete in error? 

No RepliesBe the first to reply

Resources