SQL Blog - Pieter van Maasdam, Macaw

SSIS "Failure sending mail" problem

I was trying to send an email from an SSIS package when a package failed. However, the Send Mail Task failed everytime. There was no error message except the one in the sysdtslog90 table:

 An error occurred with the following error message: "Failure sending mail.".

I found the problem was McAfee. Here's the solution:

• Open VirusScan Console
• Double-click 'Access Protection'
• Uncheck the option 'Prevent mass mailing worms from sending mail'
• Click Ok

After that, McAfee is no longer blocking the outgoing mails.

Posted 01 October 2008 13:23 by Repieter | with no comments