In the following File System Connection Manager Editor window:
6. Choose the option, an Existing file and follow though the folders till you
find Ch 16, and there in, choose to add the SendMessage.dtsx that you
created earlier.
7. Leave the other defaults as they are and click on the OK button on the
Execute Package Task Editor.
This completes configuring the OnError event handler.
You may now test and verify that when the EvntHnd.dtsx is executed, a message
will be sent to your email address as this package will generate an error (non-existent
table). Here, everything is hard coded.
Using an Event Handler in SSIS
[ 246 ]
Step 5: Add an Execute Process Task to the
OnPostExecute Event of the Renamed Default
Package
Let us take a look at adding an event handler to the OnPostExecute event. This event
is raised as soon as EvntHnd.dtsx finishes executing.
1. In the canvas of EvntHnd.dtsx, click on the Event Handler tab and choose
from the drop-down the event OnPostExecute.
Choose to add an event handler by clicking on the hyperlink on the gray
background (just like you did earlier for OnError event).
2. Drag and drop an Execute Process Task, a task when executed will bring
up a process (an executable such as Notepad.exe, Calc.exe, etc.) and then
double-click this component after placing it on the Event handler page of
the Canvas.
This brings up the Execute Process Task Editor page with the default list
item General displaying the Name and Description of the task.
Pages:
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175