Prev | Current Page 148 | Next

Jayaram Krishnaswamy

"Beginners Guide to SQL Server Integration Services Using Visual Studio 2005"


Web Service Task to Convert Miles to Kilometres
[ 222 ]
3. Type in http://localhost, as shown. Accept the other defaults and click on
Test Connection button.
You will get a Test Connection succeeded message as the web service is
created on the localhost.
The full URL of the web service http://localhost/SSIS_SVC/ForSsis.
asmx or http://127.0.0.1 can also be used. For other accessible web
services, the complete URL of the web service should be provided. For
services on the Internet, you may look up the UDDI registry. This is outside
the scope of this exercise.
4. Click on the OK button on the Microsoft Visual Studio??™s message window
as well as the HTTP Connection Manager??™s window.
A HTTP Connection Manager??™s component will be added to the Connection
Managers??™ window in the Canvas.
5. Fill in the details (as shown) for the rest of the line items so that the resulting
window display is as shown in the following screenshot. For the WSDL file,
use the location that was used for saving the source view of the browser
display.
This path is: c:\inetpub\wwwroot\ForSsis.wsdl, since the file was saved
to this location, as mentioned earlier.
Note that although there is a Download WSDL button, it does not get enabled
unless you enter the full location above. It is supposed to download the file
when the HTTP source is specified. However, it does not work as intended.
Chapter 14
[ 223 ]
6. Click on the list item Input in the Web Service Task Editor.


Pages:
136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
Na wylot hostel krakow skrzynki do internetu Teksty piosenek Działki szczecin