SSIS: Send Mail Task sending emails multiple times
I have a Send Mail Task as an event (On Error) to an Execute Package Task.
During testing when the Execute Package Task fails it rightly triggers the Send Mail Task to send an email to my account. However, instead of send the email once it sends it 6 times all at the same time as record in the received column in Outlook.
I don't know why it should be doing this (as in effect these multiple emails are spams).