Task Component Web Service Call

• Joseph Smith

  SSChasing Mays

  Points: 620

  More actions

  October 21, 2011 at 11:37 am

  #261773

  ** Edit: Sorry, the subject should read "Script Component Web Service Call"

  Hi all,

  I have a requirement to call a web service from SSIS, passing it 2 dataset parameters and receiving an integer response. After checking online, it seemed pretty straight-forward, but I'm getting an error that I can't solve:

  "Could not find default endpoint element that references contract 'TestService.TempConvertSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element."

  The web service for the requirement is one that we built, but when I started receiving this error I tried a public web service for temperature conversion at W3schools (http://www.w3schools.com/webservices/tempconvert.asmx). At first I tried using a script task from within a For loop container (multiple web services calls are required). When this error was thrown, I checked the app.config file and verified the contract attribute in the client element was correct. So I then tried to call it from a Script Component after reading an example (http://blogs.msdn.com/b/dbrowne/archive/2010/07/08/how-to-configure-an-ssis-package-to-access-a-web-service-using-wcf.aspx), but the same error was thrown.

  After reading countless posts and blogs, I've tried fully-qualified contract names, adding the servicemodel element to the DTExec.exe.config and DtsDebugHost.exe.config (and other config files) within the Microsoft SQL Server directory. I even tried using Process Monitor to find the location SSIS was checking for the configuration. None of them worked. I'm convinced it's something about where the configuration should reside on the server (all development is happening directly on the server), but I can't think of anywhere else that the servicemodel information needs to be.

  Here is the entry in the app.config file for the test service:

  <system.serviceModel>

  <bindings>

  <basicHttpBinding>

  <binding name="TempConvertSoap" closeTimeout="00:01:00" openTimeout="00:01:00"

  receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false"

  bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"

  maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536"

  messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered"

  useDefaultWebProxy="true">

  <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"

  maxBytesPerRead="4096" maxNameTableCharCount="16384" />

  <security mode="None">

  <transport clientCredentialType="None" proxyCredentialType="None"

  realm="" />

  <message clientCredentialType="UserName" algorithmSuite="Default" />

  </security>

  </binding>

  </basicHttpBinding>

  <customBinding>

  <binding name="TempConvertSoap12">

  <textMessageEncoding maxReadPoolSize="64" maxWritePoolSize="16"

  messageVersion="Soap12" writeEncoding="utf-8">

  <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"

  maxBytesPerRead="4096" maxNameTableCharCount="16384" />

  </textMessageEncoding>

  <httpTransport manualAddressing="false" maxBufferPoolSize="524288"

  maxReceivedMessageSize="65536" allowCookies="false" authenticationScheme="Anonymous"

  bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"

  keepAliveEnabled="true" maxBufferSize="65536" proxyAuthenticationScheme="Anonymous"

  realm="" transferMode="Buffered" unsafeConnectionNtlmAuthentication="false"

  useDefaultWebProxy="true" />

  </binding>

  </customBinding>

  </bindings>

  <client>

  <endpoint address="http://www.w3schools.com/webservices/tempconvert.asmx"

  binding="basicHttpBinding" bindingConfiguration="TempConvertSoap"

  contract="TestService.TempConvertSoap" name="TempConvertSoap" />

  <endpoint address="http://www.w3schools.com/webservices/tempconvert.asmx"

  binding="customBinding" bindingConfiguration="TempConvertSoap12"

  contract="TestService.TempConvertSoap" name="TempConvertSoap12" />

  </client>

  </system.serviceModel>

  If anyone can assist with this I'd GREATLY appreciate it. I've been wracking my head for 2 days on it already.

  Thanks!