Review Chapter 3 and
arrive at the fully configured package as shown in the next screenshot. The
Name of the task is "Failure Message", and the Description of the task can be
anything meaningful.
This package may be independently tested and verified.
Using an Event Handler in SSIS
[ 242 ]
Step 3: Add and Configure an Execute SQL
Task to the Renamed Default Package
1. Double-click the EvntHnd.dtsx in the Solution Explorer to bring its Canvas
into focus.
2. Drag and drop an Execute SQL Task from the Control Flow Items group in
the Toolbox onto the Control Flow page of the Canvas.
3. Right-click the Execute SQL Task component on the Canvas and from the
drop-down choose Edit (or just double-click the component).
This opens up the Execute SQL Task Editor, as shown in the following
screenshot (the numbers 1 to 5 are inserted by the author).
Chapter 16
[ 243 ]
4. At points indicated 1 and 2 on the screenshot, change the name and
description, as shown below.
5. Click on the point indicated at 3, and from the drop-down choose ADO.NET
as the connection type.
6. Click on the point indicated 4, which will bring up the
drop-down menu item, which in turn will bring up the "Configure ADO.
NET Connection Manager Editor" window.
7. Configure the Connection to connect to your SQL server, like you did in
earlier chapters.
8. At point 5, insert an invalid SQL statement, as shown below.
Using an Event Handler in SSIS
[ 244 ]
You may also use the Browse??¦button to look for a stored query on your hard drive,
and you could parse them using the ParseQuery button.
Pages:
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173