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.T
ion: The Web Service threw an error during method execution. The error is: The request failed with an empty response..
methodInfo, String serviceName, Object connection)
o methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
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.