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?