Thursday, February 14, 2013 6:09 PM
I am working on SSIS Package which includes the "Web Service Task". The Web Service Task uses the Web Service hosted on following URL -
The Web Service is hosted on some other server.
Now, When I am executing this Web Service Task, I am getting the Error as follows :
[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: Unable to connect to the remote server.
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)
Please Suggest what should be done? The Web Service takes 3 input as string, datetime & datetime. I am also passing the same inputs through the Web Service Task.
Thanks in advance.
Thursday, February 14, 2013 6:15 PM
The error message seems to be related to the access issue are you using proper login to the web service you are trying to access....
If you are running from agent account Is it having access to that?
Please mark it as helpful if it helps.
Thursday, February 14, 2013 6:20 PM
I am able to access the Hosted Web Service and Moreover the HTTP Connection Manager also having my credentials incorporated. By the way, Everything works fine on localhost (with Credentials Provided).
What can be issue ? Please suggest ...