How to fail an SSIS Task
Mark Wojciechowicz • July 8, 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
 
