MSBI Web Service Task Training in Hyderabad

Web Service Task

The Web Service task executes Web service method.

  • Writing to a variable the values Web service method returns. the highest temperature of the day from a Web service method. then use that value to update a variable used in an expression that sets a column value. 
  • Writing to a file the values Web service method returns. The list of potential customers written to a file. the file used as a data source in a package cleans the data written to a database.

    MSBI Web Service Task

    WSDL File

     The Web Service task use HTTP connection manager to connect to the Web service. The HTTP connection manager configured from the Web Service task. It referenced in the task. The HTTP connection manager specifies the server proxy settings. such as URL, credentials for accessing the Web services server, and time-out length.

    Important

     The HTTP connection manager supports anonymous authentication. It does not support Windows Authentication.  The HTTP connection manager can point to a Web site or to a Web Service Description Language file. The URL of the HTTP connection manager points to a WSDL file. The WSDL file to configure 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 copied to a local computer.
  • If the HTTP connection manager points to a WSDL file. the file 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. the methods need the responses methods return to communicate with the Web service.   the method uses input parameters of the Web Service task requires parameter values. Web service method recommends the length of sale based height in an input parameter. The parameter values provided either by strings. that defined in the task, or by variables defined in the scope of the task or a parent container. The advantage of variables is updated the parameter values by using package configurations.     Many Web service methods do not use input parameters. Web service method gets the names of presidents. the current month would not need an input parameter. the Web service can determine the current month.   The results of the Web service method written to a variable or to a file. the File connection manager specifies the file name of the variable to write the results.  
Logging Custom Messages Available on the Web ServiceTask

 The lists the custom log entries enable for the Web Service task.   WSTaskBegin: The task access a Web service. WSTaskEnd: The task completed a Web service method. WSTaskInfo: Descriptive information about the task.

The configuration of the Web Service Task

the set properties through SSIS Designer.

  • General Page Web Service Task Editor
  • Input  PageWeb Service Task Editor
  • Output Page Web Service Task Editor
  • Expressions Page
  • Set the Properties of a Task or Container