Send Mail Task

Data Transformation Services

Data Transformation Services

Send Mail Task

With the Send Mail task, you can send an e-mail message as a task. For example, if you want to notify a database administrator about the success or failure of a backup operation, you can link a Send Mail task to the preceding backup task. To use a Send Mail task, you need to install MAPI with a valid user profile on the instance of Microsoft® SQL Server™ you are running.

A Send Mail task can include attached data files. You can point to a location for an attached file and send a dynamically updated file, rather than a static copy of the file fixed when you create the task. This feature is useful for sending attachments such as log files and exception files.

Note  If an attachment file does not exist when the package is run, you will receive the message: "Error sending mail: Internal MAPI error: the address book has no directories that contain names." This message indicates that either the file is not available at the specified location or that access permissions are not granted for the file.

To add a DTS task to a DTS package