title: SQL server job / SSIS package - There was an error generating the XML document
body: <p>I currently have a problem with my SQL Server Agent Job. It used to work fine but it has stopped working all of a sudden on one of the tasks that is executed in the SSIS package.</p>
  
  <p>The SSIS package consists 6 EXACTLY THE SAME web services task with a httpconnection to a webservice. </p>
  
  <p>The data is pulled from the webservice and it is being written into an xml file which then is loaded into a SQL server database.</p>
  
  <p>Everything is configured for the job to use it properly aswell (note: it used to work without errors).</p>
  
  <p>Also when I run the package manually from data tools it doesnt give me any errors and the data is loaded perfectly fine..</p>
  
  <p>The exact error I get for one of the six tasks is:</p>
  
  <blockquote>
    <p>An error occurred with the following error message:
    "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.Webservi
    ceTaskException: Could not execute the Web method. The error is: There
    was an error generating the XML document..   at
    Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMetho
    dInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String
    serviceName, Object connection)   at
    Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServic
    eTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName,
    Object connection, VariableDispenser taskVariableDispenser)   at
    Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServic
    eTask.executeThread()".</p>
  </blockquote>
  
  <p>I have been looking into this error but I cannot find what is causing it.</p>
  
  <p>The only thing I can think of is the filesize of the XML. Five of the six XML files are no bigger than 10MB. The one that is causing the error is more than 800MB (this used to be like 1/4 of this size when it did work).</p>
  
  <p>Anyone has any ideas?</p>