Chapter 3
[ 77 ]
5. Click on the Send Mail Task.
Now you can access the properties window, as shown in the next screenshot.
You can edit the properties by clicking on the Show Editor link in this
window. This will open the Send Mail Task editor which you will be
opening by yet another method shortly
If you try to execute the package click on Email.dtsx, make a right click and
choose Execute Package, you will get a Package Validation Error message.
Click the OK button on the error message screen.
Sending Email with a SSIS Package
[ 78 ]
6. On the Send Mail Task in the Control Flow page, make a right-click to
display the drop-down. Within this menu, click on the sub-menu
item Edit??¦.
This opens the Send Mail Task Editor window, as shown in the following
screenshot, with the default branch, General.
The same editor would have shown up had you clicked on the Show Editor
hyperlink in the Send Mail Task's property window seen earlier.
This Editor has a list view in the left and the details of each of the list items
on the right. Read the instructions on this editor (the editor is used to
configure the properties of email messages sent by this package).
7. Edit the branch General. The Name and Description (both of which read,
Send Mail Task) have been changed. Now the Name reads, My Email Task
and the Description reads, Send an email using my ISP's SMTP Server. You
may use your own Name and Description.
Chapter 3
[ 79 ]
8.
Pages:
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70