Invoke a web service in SQL Server 2005 Reporting Services

To enable SQL Server 2005 Reporting Services reports to  query a web service a developer needs to know the web service namespace, method, SOAP Action, parameters, and schema of the response body. The XML data provider can query a web service directly by parsing the XML structure of the SOAP response directly. The XML Data Provider Query Language (as shown [...]

Read Full Post »