Tuesday, January 20, 2009 7:50 PMI'm trying to use a web service that is getting its data from the AS400 and I'm getting this error:
[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: Client found response content type of 'text/plain', but expected 'text/xml'. The request failed with the error message: -- <?xml version="1.0" encoding="UTF-8"?><CustomerSearch><Error>Insufficient Search Data</Error></CustomerSearch> --.. 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()".
How can I correct this?
Thursday, January 22, 2009 11:54 AMHi,
Have a read of this thread http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/f8860d82-7b99-49f6-aff2-ce4a30fdb96b/
This person had a similar problem and it turned out that the remote server was refusing the connection request so the Web Service was returning an error instead of a valid response. The above thread explains how to ascertain what the actual response is that the Web Service is returning.
.NET Webservice Studio 2.0 has been replaced with http://www.codeplex.com/wsstudioexpress
SQL Server MVP / WARDY IT Solutions, Solutions Architect
- Marked As Answer by Tony Tang_YJ Wednesday, January 28, 2009 7:03 AM