Expand Post Execution Failure Options

There currently is not any built-in functionality to execute a process on failure of an execution package.  In fact, one of our clients has had to build an external process to watch the log table in the repository database to look for a failure and then execute other processes.

I think a simple solution to this would be to allow for Running a Package upon Failure.   

That execution package could execute stored procs, outside SSIS packages, etc which would allow for various types of interaction, including sending short SMS Text Messages of a failure, creating a trouble ticket in an IT Management System, etc.



Please sign in to leave a comment.