ibcmis
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.T asks.WebSe rviceTask. Webservice TaskExcept ion: The Web Service threw an error during method execution. The error is: The request failed with an empty response..
at Microsoft.SqlServer.Dts.Ta sks.WebSer viceTask.W ebMethodIn vokerProxy .InvokeMet hod(DTSWeb MethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Ta sks.WebSer viceTask.W ebServiceT askUtil.In voke(DTSWe bMethodInf o methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Ta sks.WebSer viceTask.W ebServiceT ask.execut eThread()" .
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.
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.T
at Microsoft.SqlServer.Dts.Ta
at Microsoft.SqlServer.Dts.Ta
at Microsoft.SqlServer.Dts.Ta
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.