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