Home Forums Data Warehousing Integration Services How to Create custom error log RE: How to Create custom error log
sql Sarah
SSCrazy
Points: 2081
More actions
May 5, 2014 at 7:26 am
#1710697
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