Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


xml parsing error only on one server, though the same job runs on different servers

Posted on 2011-10-17
Medium Priority
Last Modified: 2012-05-12
Hi Experts,
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 [591]     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.
Question by:sqlcurious
LVL 16

Expert Comment

ID: 36983082
Next time it fails, get a copy of the file and scroll down to the end to see if it was truncated.

Accepted Solution

jvejskrab earned 2000 total points
ID: 36998451

Author Closing Comment

ID: 37292935

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question