sql server dts: SSIS Access Web Service -- sql server dts

SSIS Access Web Service

David Siebert
1/20/2006 12:56:02 PM

sql server dts: I am trying to access the web service of SQL Server 2005 Reporting Services
within a SSIS project in order to render a report. I have tried two methods
to achieve this, and neither has worked so far.

1. I tried using the Web Service Task. After setting a connection to the
report server (http://servername/reportserver/reportservice.asmx?WSDL) and
downloading the WSDL file, when I go to select "ReportingService" as the
service on the Input tab, I get the error "This version of the Web Services
Description Language (WSDL) is not supported."

2. I tried accessing the web service through a Script Task, but I am unable
to add a web reference to the ReportService. I am not particularly familiar
with the Visual Studio for Applications interface and limitations. Is there
any way to properly add a web reference?

I hope that I am either missing something in at least one of these two
methods, or that there is possibly some other way to achieve this. Any help
would be greatly appreciated. Thanks in advance.

Re: SSIS Access Web Service

Patrik Schneider [MSFT]
1/23/2006 2:19:15 PM

David,

For number one, you could run your WSDL through wsdl.exe (or similar) to see
if there are any warnings.

For number two, VSA doesn't allow you to add a web reference. What you can
do is one of two things: 1) generate the proxy class (wsdl yoururl
/language:vb /out:fileoutput) and add this to the Script Task's VSA project;
2) generate the proxy class and compile a separate assembly and include a
reference to that in the project. If you only plan to call the service once
the first option will mean not having to deploy a separate assembly;
however, if you're planning on making multiple calls to various methods of
the same service option two makes more sense. Option two is well documented
in Donald Farmer's book.

Hope this helps,
Patrik
--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]