The Web Service Call Component allows you to easily call (consume) a web service. It's much easier to use than the standard SQL Server Integration Services component, and can also be used from within a data-flow. To configure this component simply drag an instance onto a control-flow or data-flow surface, connect any predecessor component and double-click to configure.



You simply specify or browse to a web or local WSDL or .ASMX file, and then click the Load button. You then select the method, and can edit the URL if required. From the URL dropdown you can select a variable containing a URL, or you can also select or create a +HTTP connection. +HTTP connections define not just a URL, but also authentication details, proxy server settings, a timeout and client certificate details (these latter two can also be defined on this form).

The Parameter Bindings section allows you to specify bindings for input and output parameters. For input parameters, the format is basically text - you can type a value, or use a token (representing a value from a variable or column) by specifying them in @variable or [column] form or clicking the 'Insert Token' link, or embed tokens in the text.

For output parameters you can select to ignore the return value or bind it to a variable or column (new or existing).



All BlueSSIS data-flow components support properties 'Fail on truncation' and 'Unicode mode', allowing you to define applicable truncation and Unicode settings. These properties can be found in the Visual Studio/BIDS Properties window as shown below :