SSIS 2005 - WebServiceTask throws error when trying to call web service over SSL

Posted on 2011-04-20
Last Modified: 2012-08-13

I have deleloped a SSIS 2005 package which calls several web methods of an internally accessed web service, over SSL.

The test version of the web service is accessed over HTTP, and the web methods are called with no problems, from the WebServiceTasks in the package.

In the production version's HTTP connection manager, I specify the uri as:

same as in test (except test is at http).

Testing the connection works, and I can navigate to the url in the browser as well.

When the package executes, the webservicetask throws the following error:

Error Code: -1073548540
Error Message: 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()".

Error Source: task_MyWebServiceTask

What's making this so difficult to figure out is the fact that the error is non-descriptive, and gives no indication of what the issue is.

Any and all help is greatly appreciated.
Question by:ibcmis
    1 Comment

    Accepted Solution


    This was a tough nut to crack, but after hours and hours of searching, I found the answer here:
    Web Service -The request failed with an empty response

    Which states:

    "...but rather a solution for anyone encountering this generic error when attempting to consume a web service.

    In some server configurations, requests to port 443 (https) are resolved to port 80 (http) by an ISA server. Web services on virtual directories that are set to listen for port 80 will generate .wsdl files with http addresses, even though the correct service address is https.

    When consuming such a service, this requires either: specify the webservice.URL value to the correct https address, or correcting the .disco, .wsdl and file address values to be https rather than the http values they will pull down from the server.

    The second scenario (bolded) turned out to be my problem. In the WSDL file, the address was specified as "http://...", rather than "https://...".

    I NEVER would have thought to look there for the problem.

    Hopefully, this will help someone having a similar issue in the future.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    To properly understand GitHub, let’s divide it into two words ‘Git’ and ‘Hub’. Git is basically a ‘Distribution Version Control’ (DVC) and ‘Source Code Management’ (SCM) system widely used by software programmers while Hub means the efficient centre…
    The task of choosing a web design company to build a website for your business should never be taken in a light manner. Provided the fact that your website will act as a representative to your business and will be responsible for imposing an online …
    The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now