Professional SQL Server™ 2005 Integration Services
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
3.12. Send Mail Task
The Send Mail task can send out an e-mail message via SMTP. In SQL Server 2000, you had to send messages out through MAPI, which meant you had to install Outlook on the server that the package was running on. Now, that's no longer a requirement. The Mail page (shown in Figure 3-19) in the Send Mail Task Editor is where the configuration of this task takes place. The SMTPConnection option is where you select the SMTP Connection Manager or where you create a new one to an SMTP server.
Most of the configuration options are pretty self-explanatory in this task. One that is of special interest is the MessageSourceType option, which specifies whether the message source will be read from a file or a variable or whether it will be directly inputted into the MessageSource option.
Figure 3.19. Figure 3-19
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access