xml data source - XML Source [108]: The component "XML Source" (108)was unable to read the XML data.

Discussion in 'microsoft.public.sqlserver.dts' started by wildman, Feb 23, 2008.

  1. wildman

    wildman Guest

    RE: xml data source - XML Source [108]: The component "XML
    Source" (108) was unable to read the XML data. But only in Forevery
    loop container

    Very simple data flow. xml data source, conversion, ole db
    destination. works great stand alone outside of forevery loop
    container.

    my xml file and xsd:

    <note>
    <Customer CustId="Hello" Address="GoodBye" />
    </note>


    xsd generated from the file.


    <?xml version="1.0"?>
    <xs:schema attributeFormDefault="unqualified"
    elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/
    XMLSchema">
    <xs:element name="note">
    <xs:complexType>
    <xs:sequence>
    <xs:element minOccurs="0" name="Customer">
    <xs:complexType>
    <xs:attribute name="CustId" type="xs:string"
    use="optional" />
    <xs:attribute name="Address" type="xs:string"
    use="optional" />
    </xs:complexType>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:schema>

    I make a copy of the package and wrap it inside a container forevery
    loop with a file enum collection. Inside the data flow. I change my
    xml data source to use a variable called User::Name. I add a script
    task at the top of the container to display that as the file changes.
    it does. And when I run it I get:


    SIS package "Package.dtsx" starting.
    Information: 0x4004300A at Load XML Files, DTS.Pipeline: Validation
    phase is beginning.
    Information: 0x4004300A at Load XML Files, DTS.Pipeline: Validation
    phase is beginning.
    Information: 0x40043006 at Load XML Files, DTS.Pipeline: Prepare for
    Execute phase is beginning.
    Error: 0xC02090D0 at Load XML Files, XML Source [108]: The component
    "XML Source" (108) was unable to read the XML data.
    Error: 0xC0047019 at Load XML Files, DTS.Pipeline: component "XML
    Source" (108) failed the prepare phase and returned error code
    0xC02090D0.
    Information: 0x4004300B at Load XML Files, DTS.Pipeline: "component
    0 rows.
    Task failed: Load XML Files
    Information: 0xC002F30E at Bad, File System Task: File or directory "d:
    \jcp\xmlLoad\jcp.xml.bad" was deleted.
    Warning: 0x80019002 at Package: The Execution method succeeded, but
    the number of errors raised (2) reached the maximum allowed (1);
    resulting in failure. This occurs when the number of errors reaches
    the number specified in MaximumErrorCount. Change the
    MaximumErrorCount or fix the errors.
    SSIS package "Package.dtsx" finished: Failure.
    The program '[4332] Package.dtsx: DTS' has exited with code 0 (0x0).


    Is this some sort of file locking thing? Painfully have burnt about 33
    hours on this already.


    Thanks for any help or information.
     
    wildman, Feb 23, 2008
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.