Common SSIS package-web service tasks

A Web service task is a newly added task in SSIs. It can connect to a WebService and execute a method in the service. After the method is executed, the result can be written back to a variable or file. This task is suitable for processing information in third-party applications. For example, you can use this task to execute WebService to obtain the updated product list of Amazon and write the information to the local server.

Open HTTP Connection Manager editor in the httpconnection option on the Edit page of the web service task to create an HTTP connection. What is different from ole db connection is that HTTP connection uses a URL to specify a. asmx file. If you want to experience this connection, you can log on to www.xmethods.net. This website provides a large number of free Web Services, and most do not need to provide verification codes or other authentication. If the Web service does not require authentication, You need to modify the HTTP connection settings. In Figure 3-20, a Web service connection can be crawled on this site.

Figure 2-20

After setting the HTTP connection, return to the Web service task Editor interface. In the wsdlfile column, no Web Service Description Language (WSDL) file is selected for WebService. This file describes how the package uses the service. If you select an external site, you must copy the WSDL file to your local device. You can also set whether the overwritewsdlfile option can be rewritten.

The methods in the Service may not require any parameters. In the drop-down list of the service column, select the servcie to use and select a method from the method drop-down list. In the webmethoddocumentation column, the description of the method is automatically filled, the entered information appears in the service box. Enter the parameter to be passed, and then specify the output location on the output tab page. You can select a file or variable. In Figure 3-21, the task crawls the network in the specified URL and outputs the result to a variable. If it is output to a file, you need to use the file link Manager Configuration File Link.

Figure 3-21