"XML Source" (108) was unable to read the XML data.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • wildman@noclient.net

    "XML Source" (108) was unable to read the XML data.

    Trying to read XML files from SSIS and load into SQL Server.

    I tested this before and it was working before I placed in a forevery
    contrainer. also, my simple xml file had to be retyped cause I deleted
    by accident..

    Getting this error:

    The component "XML Source" (108) was unable to read the XML data.

    I confirmed it's pointing to right file and now it is cause failuer
    step is renaming it.

    my xsd: genereated by ssis:

    <?xml version="1.0"?>
    <xs:schema attributeFormDe fault="unqualif ied"
    elementFormDefa ult="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>

    my xml:

    <note>
    <Customer CustId="Hello" Address="GoodBy e" />
    </note>



    FULL ERROR:

    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
    "OLE DB Destination" (341)" wrote 0 rows.
    Task failed: Load XML Files
Working...