Post reply

OnError event triggers multiple times for one error

  • August 6, 2011 at 4:17 am

    #142823

    Hi, We are using SSIS 2005, Package is configured to send mail on error in the event handler.

    Its working fine. A mail is being sent in the event of failure. But the problem is mail is being sent mulitple times for one error. If the error description has 1 row then the mail is sent 1 time. If the error description has 4 rows then the mail is sent 4 times.

    Please find the snapshot of error in attached document.

    How do i avoid repeated mails. Can we have a summary instead of multiple lines for error description.

    Its a bit urgent issue. Appreciate any inputs on this. Thanks in advance

  • August 7, 2011 at 10:49 pm

    #1365013

    This should be what you need: http://agilebi.com/jwelch/2007/05/05/handling-multiple-errors-in-ssis/

    The basic principle is instead of sending a message on each OnError event, store the messages during the event and send them together afterwards (or set a flag and only send the first error). Unfortunately there's no magic button.

  • August 9, 2011 at 3:15 am

    #1365696

    Hey, Try setting "MaximumErrorCount" property of your package and control flow item to 1

    Regards,
    SMK

    --------------------------------------------------------------------------
    "If you’re not prepared to be wrong, you’ll never come up with anything original."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply