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 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=""/>

 and it all just works as expected.


damn.... I was having soooo much fun wading around in the dtsx xml file.


  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!

  2. This article spells out the problem and solution:

    Thanks for the tip

  3. Oops..

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

    SSIS & Wcf

  4. Anonymous3:29 am

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