xml parsing error only on one server, though the same job runs on different servers
Posted on 2011-10-17
I get the following error occasionaly on only one server though the same job runs on 3 different servers, job runs a SSIS package and the primary function of the SSIS
package is to copy a XML file from an FTP server and load the contents of the xml file into a database table. This package is schedule to run everyday by a job and this job runs on three different servers, but it fails occasionaly on only one server with the following message and typically its over the weekend that happens, I am clueless as to whats causing the error, please help.
Code: 0xC02092AF Source: Loading Data From XML XML Source  Description: The component "XML Source" (591) was unable to process the XML data. Unexpected end of file while parsing Name has occurred. Line 129388, position 328. End Error Error: 2011-10-14 21:20:18.31 Code: 0xC0047038 Source: Loading Data From XML SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "XML Source" (591) returned error code 0xC02092AF. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:20:00 PM Finished: 9:20:18 PM Elapsed: 17.41 seconds. The package execution failed. The step failed.