The Web Service Task in SSIS is used to retrieve XML-based result sets by executing a method on a web service. The task requires creation of an HTTP Connection Manager to a specific HTTP endpoint on a website or to a specific Web Services Description Language (WSDL) file on a website.
The WSDL file provides a standard XML-formatted list of available methods that can be called in the web service. The WSDL file also provides information about what type of parameters can be used and what results can be expected in return.
You can configure the HTTP Connection Manager to access a web service called USZIP at http://www.webservicex.net/uszip.asmx?WSDL
Simply provide the local filename and click the Download WSDL button to have the task, at design time, reach out to the HTTP endpoint and retrieve a copy of the WSDL file for you.
WSDL file contains all the available methods from the web service. The WSDL file looks like something similar to this.
Using the WSDL file to provide a dropdown in the Input tab where you can specify the method
Define the output XML file and run the package.
Cheers!
Uma
No comments:
Post a Comment