Send Mail Task Editor (Mail Page)

 

Applies To: SQL Server 2016

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.

To learn about this task, see Send Mail Task.

SMTPConnection
Select an SMTP connection manager in the list, or click <New connection…> to create a new connection manager.

System_CAPS_ICON_important.jpg Important


The SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication.

Related Topics: SMTP Connection Manager

From
Specify the e-mail address of the sender.

To
Provide the e-mail addresses of the recipients, delimited by semicolons.

Cc
Specify the e-mail addresses, delimited by semicolons, of individuals who also receive copies of the message.

Bcc
Specify the e-mail addresses, delimited by semicolons, of individuals who receive blind carbon copies (Bcc) copies of the message.

Subject
Provide a subject for the e-mail message.

MessageSourceType
Select the source type of the message. This property has the options listed in the following table.

ValueDescription
Direct inputSet the source to the message text. Selecting this value displays the dynamic option, MessageSource.
File connectionSet the source to the file that contains the message text. Selecting this value displays the dynamic option, MessageSource.
VariableSet the source to a variable that contains the message text. Selecting this value displays the dynamic option, MessageSource.

Priority
Set the priority of the message.

Attachments
Provide the file names of attachments to the e-mail message, delimited by the pipe (|) character.

System_CAPS_ICON_note.jpg Note


The To, Cc, and Bcc lines are limited to 256 characters in accordance with Internet standards.

MessageSourceType = Direct Input

MessageSource
Type the message text or click the browse button (…) and then type the message in the Message source dialog box.

MessageSourceType = File connection

MessageSource
Select a File connection manager in the list or click <New connection…> to create a new connection manager.

Related Topics: File Connection Manager, File Connection Manager Editor

MessageSourceType = Variable

MessageSource
Select a variable in the list or click <New variable…> to create a new variable.

Related Topics: Integration Services (SSIS) Variables, Add Variable

Integration Services Error and Message Reference
Send Mail Task Editor (General Page)
Expressions Page

Community Additions

ADD
Show: