Sunday, March 25, 2007

Fixing the WCF - SSIS Web Service Task problem the easy way.

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.

5 comments:

  1. Anonymous1:32 am

    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?
    Thanks for your help!

    ReplyDelete
  2. This article spells out the problem and solution:

    http://blog.webonweboff.com/2010/07/ssis-and-wcf-devil-in-wsdl.html

    Thanks for the tip

    ReplyDelete
  3. Oops..

    Link didn't auto-generate. Here it is again:

    SSIS & Wcf

    ReplyDelete
  4. Anonymous3:29 am

    I could not solve the problem because I have no such tags xml

    ReplyDelete