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:

• http://sqlblog.com/blogs/jamie_thomson/archive/2010/05/11/five-things-ssis-should-drop.aspx
• https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126247&wa=wsignin1.0
• http://sqlblogcasts.com/blogs/simons/archive/2007/07/02/SSIS---Web-Service-task-doesn-t-cut-it-but-who-cares.aspx
• http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2177e574-bfd5-43b9-accb-1aa025fdae4a/

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:

• http://www.sql-server-performance.com/articles/biz/webservce_xml_tasks_ssis_p1.aspx
• http://www.bidn.com/blogs/BillBrannen/bidn-blog/619/ssis-web-service-task-step-by-step

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