dtsx.
You will notice a series of events; the EventHnd.dtsx with the Select from
a Table Execute SQL Task fails (turns red); the Execute Package Task of the
EventHnd.dtsx's OnError event handler turns green; and the Ping the
Default Gateway Execute Process Task turns green and finally, the Failure
Message Send Mail Task turns green sending the email to your email address.
When the EventHnd.dtsx gets executed, you will also see DOS screen
flashing, showing the success of the ping operation.
Of course, you may also verify to make sure that the email message was sent
by checking your inbox (email address removed in the screenshot below).
The Event Handler belongs to a collection of Event Handlers, which may be
expanded, as shown in the following screenshot. You may also review in the
package explorer page of the Canvas. Also note in the following screenshot that
the SendMessage.dtsx is shown in the Connection Managers' page of the Canvas,
because this package is now nested within the Execute Package Task of the
"OnError" event handler.
Chapter 16
[ 249 ]
Summary
This chapter described the mechanics of setting up a package in which an event
handler is used. The package in the example, raised two events, and two event
handlers were configured. A nested package containing a Send Mail Task was
executed when the error in the main package was generated. OnPostExecute event
was handled by executing an Execute Process Task to verify the network status of
the default gateway.
Pages:
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177