If you using SSIS to move data around, you may have jobs where error notifications can't wait until the next day. It is extremely simple to add email/paging/text alerts to your SSIS package. Here is how to add simple error alerting to your SSIS package. Note this process is detailed for the MS SQL 2005 version of SSIS.
1. Click in the open space in the Control Flow designer.
2. Click the Event Handlers tab in your SSIS package.




Development



