2. In the Solution Explorer, right-click Package.dtsx and from the drop-down
menu choose the option Rename and change it to Email. Do not change the
extension; it should remain dtsx (i.e., Email.dtsx).
3. You will see a Microsoft Visual Studio warning. Click on the Yes button on
the window with the warning.
Sending Email with a SSIS Package
[ 76 ]
The package name changes in the Solution Explorer, as shown in the
following screenshot, and the package properties are displayed in the
properties window.
Observe that the Canvas is showing the Control Flow tab. This is the
Control Flow page where you will place your Control Flow Items. Read the
instructions on this page before you proceed. Now look for Send Mail Task
in the Control Flow Items group in the Toolbox.
You can bring this task onto the Control Flow page by one of the following
two methods:
4. Double click this in the Toolbox.
This task should appear on the Control Flow page, as shown in the following
screenshot:
Or, you can click on the Send Mail Task in the Toolbox and drag it into the
Control Flow page. In this case, the Send Mail Task will be placed where
you release your mouse.
You notice a green arrow pointing downwards. This will be used if you want
the control to flow to another object (at present left dangling). You also notice
a white mark (x) inside a red dot in the Send Mail Task. If you place your
mouse on top of it (hover over the mark) you get a pop-up that says that a
SMTP server is not specified.
Pages:
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69