Applies to: 
SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory
the send mail task sends an email message. Using the Send Mail task, a package can send messages if tasks in the package’s workflow succeed or fail, or send messages in response to an event that the package raises at run time. for example, the task can notify a database administrator of the success or failure of the database backup task.
You can configure the send mail task in the following ways:
-
provide the message text for the email message.
provide a subject line for the email message.
sets the priority level of the message. the task supports three priority levels: normal, low, and high.
Specify recipients on the to, cc, and bcc lines. if the task specifies multiple recipients, they are separated by semicolons.
include attachments. if the task specifies multiple attachments, they are separated by the pipe character (|).
specify the smtp connection manager to use.
The message text can be a string you provide, a connection to a file containing the text, or the name of a variable containing the text. the task uses a file connection manager to connect to a file. for more information, see flat file connection manager.
The task uses an smtp connection manager to connect to a mail server. for more information, see smtp connection manager.
custom log messages available in send mail task
The following table lists the custom log entries for the send mail task. for more information, see the integration services (ssis) log.
configure send mail task
you can set properties through the ssis designer or programmatically.
for information about the properties you can set in the ssis designer, click on the following topic:
- expression page
For information on how to set these properties programmatically, click the following topic:
- sendmail
related tasks
for information on how to set these properties in the ssis designer, click set the properties of a task or container.
related content
- technical article, how to send delivery notification email in c#, on shareourideas.com
sending mail task editor (general page)
Use the general page of the send mail task editor dialog to name and describe the send mail task.
options
name provide a unique name for the send mail task. this name is used as a label on the task icon.
note task names must be unique within a package.
description type a description of the send mail task.
send mail task editor (mail page)
Use the mail page of the send mail task editor dialog box to specify the recipients, message type, and priority of a message. you can also attach files to the message. the message text can be a string you provide, a file connection to a file containing the text, or the name of a variable containing the text.
options
smtp connection select an smtp connection manager from the list, or click <new connection…> to create a new connection manager.
related topics: smtp connection manager
from specify the email address of the sender.
to provide recipient email addresses, delimited by semicolons.
cc specify the email addresses, delimited by semicolons, of people who also receive copies of the message.
bcc specify the email addresses, delimited by semicolons, of the people who receive blind copies (bcc) of the message.
subject provide a subject for the email message.
message font type select the font type of the message. this property has the options listed in the following table.
priority sets the priority of the message.
attachments provides the filenames of the files attached to the email message, delimited by the pipe character (|).
dynamic message source type options
message source type = direct input
message source type your message text or click the browse button (…) and then type your message in the message source dialog box >.
message source type = file connection
messagesource select a file connection manager from the list or click <new connection…> to create a new connection manager.
related topics: file connection manager, file connection manager editor
message source type = variable
messagesource select a variable from the list or click <new variable…> to create a new variable.
Related topics: integration services (ssis) variables, adding variable
see also
integration services task control flow
See Also: Contact Tyler Perry [Studios] 🎥 Directly (2022) Email, Address, Agent, Manager & Publicist