Literally minutes after publishing my post on calling a WCF Web Service from the SSIS Web Service task, I checked back with the forum post that I'd mentioned in that blogpost http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1023821&SiteID=17 only to discover that Uwe Heinkel had given me the peice of information I was missing in the first place. So the crux is I don't have to hand craft the dtsx xml file to get it to play ball.
I simply remove the following line from the wsdl file
<xsd:import schemaLocation="http://localhost:50344/MyWebService/Service.svc?xsd=xsd2" namespace="http://schemas.datacontract.org/2004/07/"/>
and it all just works as expected.
damn.... I was having soooo much fun wading around in the dtsx xml file.
Posts
Hi, I was having the same problem than you but thanks to you I fixed it. Now I'm having a problem when I try to get a big string from the web service as the output, I get an error about this config parameter MaxReceivedMessageSize, so I modified this in the App.conf of the WCF but apparently I need to do it in the client also, do you know where can I do this in the package?
ReplyDeleteThanks for your help!
This article spells out the problem and solution:
ReplyDeletehttp://blog.webonweboff.com/2010/07/ssis-and-wcf-devil-in-wsdl.html
Thanks for the tip
Oops..
ReplyDeleteLink didn't auto-generate. Here it is again:
SSIS & Wcf
Thanks Scott
ReplyDeleteI could not solve the problem because I have no such tags xml
ReplyDelete