[this intelligent life]

Blog Post

How to fail an SSIS Task

Mark Wojciechowicz • Jul 08, 2017

SSIS allows the ability to force a task to fail in order to test unhappy paths. It's a bit confusing about how to do this because you could do any of the following:

  • Add an error to a sql task like divide by zero
  • Set the execution result to failure in a script task
  • Change the Forced execution value in the property of the task
The first two options could work, but for the purposes of avoiding changing code, you can just set the ForceExecutionResult property for the task as shown below. The other execution result properties do not do anything and fail package on failure will not help either.


Share by: