MS SQL Server DTS - SSIS Access Web Service

Author

SSIS Access Web Service

David Siebert

2006-01-20, 8:24 pm

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.

David

Patrik Schneider [MSFT]

2006-01-23, 8:24 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.

"David Siebert" < DavidSiebert@discuss
ions.microsoft.com> wrote in message
news:39EC5A1A-343A-4C68-B9DE- DC55A8DDAABE@microso
ft.com...
>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.
>
> David

Sponsored Links