The Web Service task is a newly added task in SSIS that connects to a webservice and executes a method in the service. After executing the method, you can write the results back to a variable or file. This task is suitable for handling information in third-party applications. For example, you can use this task to execute the method in webservice to get Amazon's updated product list and write this information to a local server.
In the edit page of the Web Service task, in the Httpconnection option, open the HTTP Connection Manager editor to create a new HTTP connection. Unlike OLE DB connections, the HTTP connection uses a URL that is specified to one. asmx file. If you want to experience this connection, you can log in to Www.xmethods.net, which provides a lot of free web services, and most of them do not need to provide verification codes or other certifications. If the Web service does not require authentication, you need to modify the HTTP connection settings. A Web service connection given in Figure 3-20 can be crawled in this site.
Figure 2-20
After you set up the HTTP connection, go back to the Web Service Task editor interface in the Wsdlfile bar without webservice selecting the Web service Description Language (WSDL) file. This file describes how the package will use the service. If you select an external site, you must copy the WSDL file locally. Within the Overwritewsdlfile option, you can also set whether you can override it.
The methods in the service may not require parameters, select the Servcie to use in the drop-down list of the services bar, select a method in the methods drop-down list, and the Webmethoddocumentation column will automatically populate the description of the method. The information entered will appear in the service box. Enter the parameters you want to pass, and then specify where you want the results to be printed in the Output tab interface, and you can select a file or a variable. In Figure 3-21, the task crawls through the specified URL, outputting the result to a variable. If you are exporting to a file, you need to use the File Link Manager profile link.
SSIS Common Package-web service tasks