It is self-contained and modular.
It uses a standard XML messaging system.
It is both a programming language and an operating system (Platform)
agnostic, as it is based on XML.
The web service is described by WSDL, and WSDL is discovered by UDDI.
For details about web services, the best source is W3C (http://www.w3.org/2002/
ws/). The Web Service Task is a new task in SSIS and did not have a counterpart
in DTS.
In order to follow the steps as indicated, you will need a web service and the
required information to access the service that is usually called the WSDL [Web
Services Description Language]. WSDL completely describes the web service that
can be accessed over the Internet. In this exercise, the web service will be accessed
over the intranet whose URL is http://localhost. This URL is that of the default
IIS web server, which is assumed to be present. Readers will benefit from reading the
web service articles, written from different perspectives, whose links are found in
this blog (http://hodentek.blogspot.com/2007/02/links-to-my-articles-onweb-
services.html).
??? ??? ??? ??? ???
Web Service Task to Convert Miles to Kilometres
[ 214 ]
Hands-On Exercise: Creating and Testing
a Package that Uses a Web Service Task
This exercise consists of two parts, the first part describes how the web service is
created and how the associated WSDL file that is necessary for the Web Service Task
was obtained. In the second part, configuration of the Web Service Task in the SSIS
will be described.
Pages:
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155