Now click on the branch Mail. This brings in the Mail window on the right
side as shown in the following screenshot.
Here, there are a number of items, with some of them having options. You
may notice, however, that a lot of them are familiar to you if you have used
any of the email programs; such as: FROM, TO, Cc, BCc, Subject, Priority,
Attachments, etc. The choices made are typed into the text boxes, as shown
in the above screenshot. If needed, you can indicate attachments by clicking
on the Attachments field, which opens up a window, Open, where you can
navigate to locate the file you want as an attachment. For this exercise, the
Attachments and the BCc fields are left blank.
Sending Email with a SSIS Package
[ 80 ]
9. Now click on an empty area along the line item SMTP Connection.
In the drop-down menu, click on New Connection.... This brings up the window
shown in the following screenshot.
10. Fill in the details, as shown in the next paragraph, and click on the
OK button.
For Description, type in a suitable description of your choice such as "My
ISP's SMTP Server" and in the SMTP server field type in the name of the
SMTP Server provided by your ISP, like SMTP.myISP.com.
This enters the SMTP server information into the Send Mail Task Editor.
For the MessageSourceType, we have accepted the default, Direct Input.
For the MessageSource, directly type-in the message Testing the Send Mail
Task with Direct Input and My ISP's SMTP Server as shown in the window
named "Message Source", or in the window (a small text editor window) that
pops-up when you click on the ellipsis button in the MessageSource field.
Pages:
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71