• I use an Exec SQL task. Create a data source that connects to msdb and use the system stored procedure dbo.sp_send_dbmail

    Here is the TechNet article describing it:

    http://technet.microsoft.com/en-us/library/ms190307.aspx