Chapter 3
[ 81 ]
This completes all the required fields, as shown in the following screenshot.
In this exercise, we used the default Direct Input for the MessageSource-
Type field in the above window. There are two other options: File
Connection and Variable. If you were to choose File Connection, you will
have to tell the wizard where the file is located. On the other hand, if you
choose Variable, then the wizard will look for a variable you might have
created to pull its value. The main objective in the present chapter is to
describe the simplest of the many possible variations.
Sending Email with a SSIS Package
[ 82 ]
When you click on the Expressions list item in the left, it opens a window,
as shown in the next screenshot. You may want to use an expression to
evaluate a function of a type (by this, return value of function is meant) such
as a string or a date (given today's date, a future date or a date in the past,
for example) and use that calculated value in the task.
Here, the Expressions window is not configured. However, you can
configure this window by associating a variable (that you define) to one of
the allowed Property Expressions such as the cc, bcc, subject and other fields
of the email that you are sending. In this exercise, to keep the explanation to
bear minimum, Expressions list item is left empty.
11. Click on the OK button in the Send Mail Task Editor.
Review the changes made to the Send Mail Task property window.
Pages:
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72