Has anyone pulled a large number of small records from a WebService? Can you work with the data without writing it to a disk file?
Right now I have a web service that has 2 methods, method 1 I can pull the data from and write it to a file fine (7475 records) . But I really want the data in method 2, that crashes when I read it to a file or variable. (Do I have other choices?) I do not know exactly how many records method 2 is pulling, I expect around 33000.
I have a HTTP Connection being used by a WebService Task in an SSIS package. The provider of the WebService swears there is no error in the XML...
But I get:
, Web Service Task: 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: There is an error in XML document (1, 3502230)..
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)
And nothing in the variable or file.