ssis:force_to_fail_an_expression_for_testing

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

  • ssis/force_to_fail_an_expression_for_testing.txt
  • Last modified: 2021/05/06 10:03
  • by chongtin