Finally found what I needed to avoid SSIS from failing the package and ignoring the error in the Task:
http://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/
Just one tiny hidden System variable "Propagate" was able to resolve my issue on custom error handling in the SSIS Package.
Great, thanks!
ReplyDelete