Web Service Task - Empty Response

• paul 31908

  SSC Enthusiast

  Points: 136

  More actions

  July 12, 2017 at 9:48 am

  #331798

  Hi all,

  I have been trying to work out how to use the Web Service task to bring in data from third party web services.  I have followed a nuymber of tutorials, but always get the same error.  I am sucesfully able to connect and download the WDSL, but when I execute the task, I get the following error:

• [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: The request failed with an empty response..
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

For example, this tutorial I have followed to the letter.  
http://bidn.com/blogs/BillBrannen/bidn-blog/619/ssis-web-service-task-step-by-step

I then also tried other web services on the webservisex site.  All produce the same empty response error.
I have tried different networks too in case this was a proxy related issue.