SSIS: Fail 'Execute SQL Task' container based on returned result.
I have an SSIS package which has a 'Execute SQL Task' componenet. This task calls some SQL and returns 0 if everything is OK and 1 if an error has been found. This code is all working as expected. What I am looking for is a way to fail the component if the return code is > 0.
The 'Execute Process Task' has similar functionality where you can use the 'FailTaskIfReturnCodeIsNotSuccessValue' and 'SuccessValue' fields. I need the equivelent functionality for the 'Execute SQL Task'.