woensdag 11 augustus 2010

Web Service Task : "The selected Web method contains unsupported arguments"

Hi,

In a former post of mine i used a script task in SSIS for connecting to a webservice. When hovering the toolbox in SSIS i noticed a Web Service Task and i thought: "Why not try this for connecting to the Bing webservice for getting the geocode information". Okay...well that isn't that simple.  So i started to set up a HTTP connection manager. Something like this:



The next thing is to setup the Web Service Task:



Hey, what's that ? : "The selected Web method contains unsupported arguments.". Searching the internet, it appears to me that the Web Service Task is very.... very limited as i read on several blogs:
As Simon Sabin complains, there is no documentation about the unsupported features. I think that the Web Service Task is built on a certain WSDL version and newer versions are not supported (still in 2008 R2!).

I've seen some examples that do work:
So i've read a couple of posts of people who did find a solution by adjusting the WSDL file, by dropping or commenting out some elements that are beyond SSIS capabilities:
  • Deleting complextypes from WSDL File.
  • There's an issue with GUID
May be the best advice is: DON'T USE THE WEBSERVICE TASK AND USE THE SCRIPT TASK!
The book "Professional Microsoft SQL Server 2008 Integrations Services" tells me that the web service task is not a common source for large volumes of data and this is why Microsoft doesn't pay a lot of attention to this feature, off course.

Gr,
Hennie

Geen opmerkingen:

Een reactie plaatsen