Link to home
Start Free TrialLog in
Avatar of ibcmis
ibcmisFlag for United States of America

asked on

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

Hello,

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:

https://mycompany.subdomain.com/mywebservice.asmx?wsdl

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.
ASKER CERTIFIED SOLUTION
Avatar of ibcmis
ibcmis
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial