Right-click the Ch 14 solution in the explorer and from the drop-down
choose Add|New Project??¦
This opens the Add New Project window where you choose to add a SSIS
project, as shown in the following screenshot.
2. Rename the project. In this exercise, it was renamed WSVC and the default
package.dtsx was renamed MileKm.dtsx, as shown below.
Web Service Task to Convert Miles to Kilometres
[ 220 ]
3. Drag and drop a Web Service Task from the Control Flow Items group in
the Toolbox onto the Control Flow page of the Canvas.
The default name of this Web Service Task will be changed while editing this task in
the next step.
Step 2: Configuring the Web Service Task
1. Right-click the Web Service Task component and from the drop-down click
on Edit??¦
This opens the Web Service Task Editor??™s window.
This window has four list items in the left and each of them open their own
interactive settings window on the right. For the list item General, the
following information needs to be given:
HTTP Connection ?? The protocol used to access the service.
Chapter 14
[ 221 ]
WSDL file ?? Web Services Description Language, an XML formatted file
that describes network services as endpoints for messages. (The process
of deriving this file was described earlier).
2. Click on an empty area in the HTTP line item at a location x, as shown. From
the drop-down click on
.
This opens the HTTP Connection Manager??™s window. The HTTP will be
requesting directly from the intranet, http://localhost.
Pages:
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159