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.

Check point is the main feature to achieve this.

Make sure you need to set FailPackageonFailure to True, Give path of Checkpoint XML file, Enable Checkpoint to True.

You can send mail to as in .Net using SMTP mail, Mail Task (SEt multiple account with , separated in TO, CC, BCC field.)

Checkpoint - the excellent feature MS intoduce into the SSIS (in comparison to DTS) which restart SSIS Pkg from previous point of failure.

For sending mail "Sendmail" and "DB Mail" for sending multiple recipients whatever we are using normally in any mail client - separating the names by ";".

Thanks Manoj

Checkpoint can be enabled for the package. This will enable to restart the package from the point of failure, by restoring the parameter values from the xml file configured for checkpoint.

There are mainly three ways of sending emails. They are Send Mail task--Direct task to send email from SSIS Script task: Can be used to send email by writing the script inheriting the namespace, system.net.Mail DBMail: This can also be used to send email using spsenddbmail system procedure.

Multiple email ids can be added to To list by seperating each email id by Semicolon(;).