Solved

SSIS: Send Mail Task sending emails multiple times

Posted on 2014-01-09
1
1,476 Views
Last Modified: 2016-02-10
Hi All,

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).

Thanks,

OS
0
Comment
Question by:onesegun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
onesegun earned 0 total points
ID: 39767661
Ok I found the solution myself.

Instead of using On Error I have used On Task Failed.

OS
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
query optimization 6 29
Compare a column in results by values left of decimal 2 29
How to keep a record with the highest value 3 55
Linked Server - SP with Param to VIew 7 29
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question