Web Service and the AS400


  • I'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? 

    Tuesday, January 20, 2009 7:50 PM