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/
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
- Deleting complextypes from WSDL File.
- There's an issue with GUID
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 posten