Force to Fail an Expression for Testing
- Add an expression task
- set the expression to an always true one such as
1==1 - In
propertiessetting of the expression taskmisesection, setForceExecutionResulttoFailure
Learn it from here: https://www.thisintelligentlife.net/how-to-fail-an-ssis-task