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

Posted on 2011-10-17
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

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

    Accepted Solution


    Author Closing Comment


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    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.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now