asmx?WSDL) to the WSDL by displaying an XML file that
completely describes the web service.
1. Click on the Service Description hyperlink after browsing to the ForSsis.
asmx file in the Solution Explorer using Internet Explorer.
Web Service Task to Convert Miles to Kilometres
[ 218 ]
The browser display of the file, with several nodes in collapsed state, is
shown in the next screenshot.
The web service task editor in the SSIS designer would return an error if
one were to use the URL web reference shown in the previous screenshot.
The reason for this is that the Web Service Task user interface is expecting a
reference to a folder location on the machine. There are a couple of ways to
generate this file. The easiest would be to save the source view of the above
browser display to a location of your choice with the extension WSDL.
2. In the IE browser click on View|Source.
This opens up Notepad displaying an XML file.
3. Save the file (by renaming the source file to ForSsis.wsdl) to a location of
your choice with the extension WSDL.
In this exercise, it is saved to C:\Inetpub\wwwroot.
Part Two
The following steps will be described in setting up a BI project that creates a package
containing a Web Service Task. The Web Service Task will call the Web Service
created in Part one.
Creating a BI project and adding a Web Service Task.
Configuring the Web Service Task.
Building the BI project and executing the package.
??? ??? ???
Chapter 14
[ 219 ]
Step 1: Creating a BI project and Adding a Web
Service Task
1.
Pages:
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158