Send Mail Task

Overview

Send Mail Task Plus is SSIS Control Flow task for sending e-mails. The task can also S/MIME sign and encrypt mails.

Setup

Use the General page of the Send Mail Task Editor dialog to configure the options needed to send e-mails.

Options

Name

Specify task name.

Description

Specify task description.

IsNewMail

Indicates whether the task creates new mail. This property has the options listed in the following table.

Value	Description
True	The task creates new mail. Selecting the value displays the dynamic option From, IsSubjectVariable, Subject, SubjectVariable, ToSource, ToDirect, ToFile, ToVariable, CcSource, CcDirect, CcFile, CcVariable, BccSource, BccDirect, BccFile, BccVariable, BodyTextSource, BodyTextDirect, BodyTextFile, BodyTextVariable, BodyHtmlSource, BodyHtmlDirect, BodyHtmlFile, BodyHtmlVariable, Priority, IsAttachmentVariable, Attachment, AttachmentVariable.
False	The task loads existing mail. Selecting the value displays the dynamic options IsSourceVariable, Source, SourceVariable.

From

Specify the mail sender email address.

IsSubjectVariable

Indicates whether the mail subject is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The mail subject is stored in a variable. Selecting the value displays the dynamic option SubjectVariable.
False	The mail subject is directly specified. Selecting the value displays the dynamic option Subject.

Subject

Specify mail subject line.

SubjectVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

ToSource

Specify mail recipients source. This property has the options listed in the following table.

Value	Description
Direct input	Mail recipients are directly specified. Selecting the value displays the dynamic option ToDirect.
File connection	Mail recipients are loaded from file. Each email can be on a separate line. Selecting the value displays the dynamic option ToFile.
Variable	Mail recipients are loaded from variable. Selecting the value displays the dynamic option ToVariable.

ToDirect

Specify mail recipients. Each email is separated with semicolon.

ToFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

ToVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

CcSource

Specify other mail recipients source. This property has the options listed in the following table.

Value	Description
Direct input	Other Mail recipients are directly specified. Selecting the value displays the dynamic option CcDirect.
File connection	Other mail recipients are loaded from file. Each email can be on a separate line. Selecting the value displays the dynamic option CcFile.
Variable	Other mail recipients are loaded from variable. Selecting the value displays the dynamic option CcVariable.

CcDirect

Specify other mail recipients. Each email is separated with semicolon.

CcFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

CcVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

BccSource

Specify source for mail recipients, which are not revealed. This property has the options listed in the following table.

Value	Description
Direct input	Hidden mail recipients are directly specified. Selecting the value displays the dynamic option BccDirect.
File connection	Hidden mail recipients are loaded from file. Each email can be on a separate line. Selecting the value displays the dynamic option BccFile.
Variable	Hidden mail recipients are loaded from variable. Selecting the value displays the dynamic option BccVariable.

BccDirect

Specify hidden mail recipients. Each email is separated with semicolon.

BccFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

BccVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

BodyTextSource

Specify mail body text source. This property has the options listed in the following table.

Value	Description
Direct input	Mail body text is directly specified. Selecting the value displays the dynamic option BodyTextDirect.
File connection	Mail body text is loaded from file. Selecting the value displays the dynamic option BodyTextFile.
Variable	Mail body text is loaded from variable. Selecting the value displays the dynamic option BodyTextVariable.

BodyTextDirect

Specify mail body text.

BodyTextFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

BodyTextVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

BodyHtmlSource

Specify mail HTML body source. This property has the options listed in the following table.

Value	Description
Direct input	Mail HTML body is directly specified. Selecting the value displays the dynamic option BodyHtmlDirect.
File connection	Mail HTML body is loaded from file. Selecting the value displays the dynamic option BodyHtmlFile.
Variable	Mail HTML body is loaded from variable. Selecting the value displays the dynamic option BodyHtmlVariable.

BodyHtmlDirect

Specify mail HTML body.

BodyHtmlFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

BodyHtmlVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

Priority

Specify mail priority. These are the available options: Low, Normal, High.

IsAttachmentVariable

Indicates whether the mail attachments list is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The mail attachments list is stored in a variable. Selecting the value displays the dynamic option AttachmentVariable.
False	The mail attachments list is directly specified. Selecting the value displays the dynamic option Attachment.

Attachment

Specify mail attachments list. Separate each attachment with semicolon.

AttachmentVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

IsSigned

Indicates whether the mail should be signed. This property has the options listed in the following table.

Value	Description
True	The mail has to be signed. Selecting the value displays the dynamic options IsPrivateKeyVariable, PrivateKey, PrivateKeyVariable, Password.
False	The mail should not be signed.

IsPrivateKeyVariable

Indicates whether the private key file path is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The private key file path is stored in a variable. Selecting the value displays the dynamic option PrivateKeyVariable.
False	The private key file is specified in a File connection manager. Selecting the value displays the dynamic option PrivateKey.

PrivateKey

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

PrivateKeyVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

Password

Specify private key password.

IsEncrypted

Indicates whether the mail should be encrypted. This property has the options listed in the following table.

Value	Description
True	The mail should be encrypted. Selecting the value displays the dynamic options , IsCertificateVariable, Certificate, CertificateVariable.
False	The mail should not be encrypted.

IsCertificateVariable

Indicates whether the certificate file path is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The certificate file path is stored in a variable. Selecting the value displays the dynamic option CertificateVariable.
False	The certificate file path is specified in a File connection manager. Selecting the value displays the dynamic option Certificate.

Certificate

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

CertificateVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

Location

Indicates mail delivery location. This property has the options listed in the following table.

Value	Description
Server	The mail is delivered to mail server. Selecting the value displays the dynamic option SmtpConnection.
File	The mail is saved as file. Selecting the value displays the dynamic options IsTargetVariable, Target, TargetVariable, OverwriteExisting.

SmtpConnection

Select an existing SMTP2 connection manager, or click <New connection...> to create a connection manager.

Related topics: SMTP Connection Manager Editor

IsTargetVariable

Indicates whether the target file path is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The target file path is stored in a variable. Selecting the value displays the dynamic option TargetVariable.
False	The target file path is specified in a File connection manager. Selecting the value displays the dynamic option Target.

Target

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager Editor

TargetVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

OverwriteExisting

Specify whether target file can be overwritten.