When this component
executes, it will go and look for a table called Test on the Local SQL Server. As there
is no table by this name, the component would fail and generate an error. You may
execute and verify that it fails.
Step 4: Add an Execute Package Task to
the OnError Event of the Renamed Default
Package
1. Click on the Event Handler tab of the EvntHnd.dtsx package.
The page opens with the OnError Event Handler, as shown in the following
screenshot, but with a gray background. Click on the link, Click here to create
a, 'OnError' error-handler for package 'EvntHnd'.
2. Drag and drop an Execute Package Task, as shown in the following
screenshot.
The Execute Package Task gets executed when the error is raised due to the
failed package EvntHnd.dtsx.
3. Double-click the Execute Package Task component.
This opens up the Execute Package Task Editor with display showing the
contents of the General list item. You may change them suitably to reflect the
scenarios you are planning. Here it was left as is.
Chapter 16
[ 245 ]
4. Click on the Package list item on the left.
This will open the details of the package that needs to be executed such as its
location (as shown in the following screenshot). This location can be on the
SQL Server or the local file system, as shown below.
5. Choose File system and on the next line you need to point to a Connection.
Click on an empty area here and click on the drop-down menu
connection??¦>.
Pages:
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174