When the first package fails, you will use
the OnError event to execute the other package. Simultaneously, when the
first package finishes executing you verify that you can successfully ping your
default gateway.
The following steps will be described in setting up a BI project with two packages:
Create a BI project and rename the default package.
Add and configure the package that has a Send Mail task.
Add and configure an Execute SQL Task to the renamed default package.
Add an Execute Package Task to the OnError event of the renamed
default package.
Add an Execute Process Task to the OnPostExecute event of the renamed
default package.
Build and execute the package with event handlers and verify.
Step 1: Create a BI Project and Rename the
Default Package
1. Create a Business Intelligence Project Ch 16 and rename the default file
Package.dtsx to EventHnd.dtsx.
2. Right-click the SSIS Packages folder in the Solution Explorer and from the
drop-down click on New SSIS Package, as shown in the following screenshot.
This adds a Package1.dtsx.
??? ??? ??? ??? ??? ???
Chapter 16
[ 241 ]
3. Rename the file name to SendMessage.dtsx.
The Solution Explorer will display two packages, as shown below.
Step 2: Add and Configure the Package that
has a Send Mail Task
1. Double-click the SendMessage.dtsx in the Solution Explorer.
This brings up the Canvas for the SendMessage.dtsx package.
2. Add and configure a Send Mail Task.
Chapter 3 describes the Send Mail Task in great detail.
Pages:
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172