posted 1/27/2012 by ChrisAlbrektson - Views: [293]
Do you know what Notification Framework is? The primary objective for notification framework is to alert you about certain events in your SSIS package. This notification framework will alert you through email and/or SMS if your package fails along with details to help you troubleshoot the issue. As with all the other features included with BIxPress this is a very simple process and something most developers shouldn’t live without. Let’s explore this feature and I will show you how to implement this into your SSIS packages.
First, right click on the package in the solution explorer and select ‘Add/Remove Notification Framework’
Then use the default value of ‘Add/Update Notification Framework’ from the wizard and then select next.
From this screen simply select where your SSIS packages are stored then choose either 1 or all packages then click next.
Alright, and now we start to get to the important items. As you can see from the image below you can choose what events you want to include and exclude from the notifications. You have the options to pick how (Email, SMS, Event Log, Log to File) and when (immediately, Completion) you want to be notified.
The next to last step you simply need to setup the SMTP, Emails, and SMS settings.
The last step you will simply click start and BIxPress will add the notification framework to your package. If you have been reading any of my other blogs about BIxPress over the last few weeks you can see these are extremely easy to setup and only take a matter of a few minutes. One other quick note about this feature is that it requires no additional items to be installed on the server.
Now if any of your packages start to fail you can be notified along with the important details of why when you receive your email or SMS.
To learn more about this feature click here. If you want to find out more about some of the other features of BIxPress or get a free trial click here.