txt file in the My Documents directory (perhaps you may have to
refresh the view).
Creating a SSIS Package to Access Folders and Files
[ 192 ]
Step 3: Adding a Send Mail Task to the
Control Flow Page on the Canvas
Please read up Chapter 3 where the Send Mail Task was discussed. The next
screenshot shows a partially configured Send Mail Task that will email a file to
mysorian@gmail.com.
Since File Connection option will be chosen for the MessageSourceType,
a MessageSource.
Chapter 12
[ 193 ]
1. Click on an empty area along the line item MessageSource (in the second
column), which enables a drop-down handle. Click on this handle.
The drop-down menu shows the existing two file system connection managers,
as well as an option to create a new connection.
Creating a SSIS Package to Access Folders and Files
[ 194 ]
2. Click on CopiedPrince.txt since this was the one copied by the File System
Task. Now for the line item Subject type in some text (Sending CopiedPrince
in here).
The completed Send Mail Task is as shown below.
3. Click on the OK button in the Send Mail Task Editor and you are done.
Now you can execute the Send Mail Task, which will email the file shown in
the above editor to the destination email address.
Chapter 12
[ 195 ]
Using Precedence Constraint to Send Mail
In the present exercise, the File System Task and the Send Mail Task are two
executables (you can independently execute) and we want the File System Task to
create the file in the chosen destination and only then, the Send Mail Task will email
this file.
Pages:
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145