Web Service Task

The Web Service task executes a Web service method. You can use the Web Service task for the following purposes:

  • Writing to a variable the values that a Web service method returns. For example, you could obtain the highest temperature of the day from a Web service method, and then use that value to update a variable that is used in an expression that sets a column value.
  • Writing to a file the values that a Web service method returns. For example, a list of potential customers can be written to a file and the file then used as a data source in a package that cleans the data before it is written to a database.

The Web Service task uses an HTTP connection manager to connect to the Web service. The HTTP connection manager is configured separately from the Web Service task, and is referenced in the task. The HTTP connection manager specifies the server proxy settings such as the server URL, credentials for accessing the Web services server, and time-out length. For more information, see HTTP Connection Manager.

The HTTP connection manager can point to a Web site or to a Web Service Description Language (WSDL) file. The URL of the HTTP connection manager that points to a WSDL file includes the ?WSDL parameter: for example, http://MyServer/MyWebService/MyPage.asmx?WSDL.

The WSDL file must be available locally to configure the Web Service task using the Web Service Task Editor dialog box that SSIS Designer provides.

  • If the HTTP connection manager points to a Web site, the WSDL file must be copied manually to a local computer.
  • If the HTTP connection manager points to a WSDL file, the file can be downloaded from the Web site to a local file by the Web Service task.

The WSDL file lists the methods that the Web service offers, the input parameters that the methods require, the responses that the methods return, and how to communicate with the Web service.

If the method uses input parameters, the Web Service task requires parameter values. For example, a Web service method that recommends the length of skis you should purchase based on your height requires that your height be submitted in an input parameter. The parameter values can be provided either by strings that are defined in the task, or by variables defined in the scope of the task or a parent container. The advantage of using variables is that they let you dynamically update the parameter values by using package configurations or scripts. For more information, see Integration Services Variables and Package Configurations.

Note

The Web Service task supports parameters of the following data types only: primitive types such as integers and strings; arrays and sequences of primitive types; and enumerations.

Many Web service methods do not use input parameters. For example, a Web service method that gets the names of presidents who were born in the current month would not require an input parameter because the Web service can determine the current month locally.

The results of the Web service method can be written to a variable or to a file. You use the File connection manager either to specify the file or to provide the name of the variable to write the results to. For more information, see File Connection Manager and Integration Services Variables.

Custom Logging Messages Available on the Web Service Task

The following table lists the custom log entries that you can enable for the Web Service task. For more information, see Implementing Logging in Packages and Custom Messages for Logging.

Log entry Description

WSTaskBegin

The task began to access a Web service.

WSTaskEnd

The task completed a Web service method.

WSTaskInfo

Descriptive information about the task.

Configuring the Web Service Task

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in SSIS Designer, click one of the following topics:

For more information about how to set these properties in SSIS Designer, click the following topic:

Configuring the Web Service Task Programmatically

For more information about programmatically setting these properties, click one of the following topics:

See Also

Concepts

Integration Services Tasks
Creating Package Control Flow

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Added table of custom log entries.

14 April 2006

Changed content:
  • Added information about using variables to provide the values of input parameters to the Web method.