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