Force to Fail an Expression for Testing

  1. Add an expression task
  2. set the expression to an always true one such as 1==1
  3. In properties setting of the expression task mise section, set ForceExecutionResult to Failure

Learn it from here: https://www.thisintelligentlife.net/how-to-fail-an-ssis-task