Applies to:SQL Server
SSIS Integration Runtime in Azure Data Factory
The Send Mail task sends an e-mail message. By using the Send Mail task, a package can send messages if tasks in the package 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 about the success or failure of the Backup Database task.
You can configure the Send Mail task in the following ways:
Provide the message text for the e-mail message.
Provide a subject line for the e-mail message.
Set the priority level of the message. The task supports three priority levels: normal, low, and high.
Specify the recipients on the To, Cc, and Bcc lines. If the task specifies multiple recipients, they are separated by semicolons.
Note
The To, Cc, and Bcc lines are limited to 256 characters each in accordance with Internet standards.
Include attachments. If the task specifies multiple attachments, they are separated by the pipe (|) character.
Note
If an attachment file does not exist when the package runs, an error occurs.
Specify the SMTP connection manager to use.
Important
The SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication.
The message text can be a string that you provide, a connection to a file that contains the text, or the name of a variable that contains 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 Logging Messages Available on the Send Mail Task
Use the General page of the Send Mail Task Editor dialog box to name and describe the Send Mail task.
Options
Name
Provide a unique name for the Send Mail task. This name is used as the label in 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 recipients, message type, and priority for 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 that contains the text, or the name of a variable that contains the text.
Options
SMTPConnection
Select an SMTP connection manager in the list, or click <New connection...> to create a new connection manager.
Important
The SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication.
This article discusses how to update the property of an SSIS object at runtime by creating a property expression. Provides some examples to demonstrate this feature.
Email continues to be the primary and preferred method of communication for many businesses. In some situations, emails are also received as official electronic forms of approval. This module will provide you with a list of best practices that you can follow by using Microsoft Power Automate for outgoing and incoming emails.