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