469,927 Members | 1,870 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

"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 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>

my xml:

<note>
<Customer CustId="Hello" Address="GoodBye" />
</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
Feb 23 '08 #1
0 3747

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by David List | last post: by
3 posts views Thread by Chris | last post: by
1 post views Thread by Winterminute | last post: by
43 posts views Thread by Christoph Schneegans | last post: by
3 posts views Thread by lisa.bogart | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.