Checkpoint feature of SSIS can be used to restart a package from the previous failure point. This feature uses an xml file to save the package execution information and when the package is executed after a filiure, the xml file is used to check which task failed last time and the package execution will resume from that task onwards.
Various methods to send mails:
- Script task: Using various System.Net.Mail methods mail can be easily customized. Helpful in sending html format mails and various other formating flexibilities.
- Execute SQL task to use SQL DBMail feature
- Send Mail Task: If only plain text mail has to be sent then this taks can be used. It does not require much of coding like script task and only needs to be configured properly.
Multiple recipients can be specified in the "To" option in send mail task by seperating each recipient using semi-colon (;). "To" can have a maximum length of 255 characters. So if "To" list exceeds this limitation, the send mail task has to be executed multiple times. Save all the recipients in an object variable and use a for each loop to iterate through all the individual values stored in the object variable. Have the send mail task in for each loop to send the mail.
Replied on Jun 24 2011 5:08AM