You can
rename them. Here the Ping the Default Gateway is used for the Name. For
the Description Check if default gateway is accessible was used.
3. Click on the Process list item, which opens up the window where in you
need to supply information as to what process you want it to run, as shown
in the following screenshot.
Chapter 16
[ 247 ]
In this task, we would like to ping the default gateway of this network, which
happens to be at the IP address, 192.168.1.1. (You may type ipconfig /all
at a DOS prompt to get the IP address of your default gateway.) If there is no
response, then the Internet is not accessible.
Windows IP Configuration
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 192.168.1.100
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1
The ping.exe is usually found at the windows directory in Microsoft Windows
OS.
4. Modify the entries in the Execute Process Task Editor, as shown in the
following screenshot. You may have to browse the file system to locate the
file path for the executable. Clicking on an empty area along the line item
Executable would open the dialogue for locating the path.
This completes the second event handler for the EvntHnd.dtsx package.
Using an Event Handler in SSIS
[ 248 ]
Step 6: Build and Execute the Package with
Event Handlers and Verify
1. Build the Project Ch 16 and execute the package EvntHnd.
Pages:
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176