Can anyone help me plz, I'm trying to load some XML files into SQL Server Database 2008 R2 using SSIS package.
Both XML and XSD seems to be compatible and xml source task flow in the SSIS package passed reading the xml file but it doesn't write any data into the tables, I'm assuming the problem with the XSD file, but I don't know what is the problem with it because it looks correct!!! can anybody help plz?
xml file
<?xml version="1.0" encoding="UTF-8"?> <TASK_EXTRACT> <EXTRACT_TS>2014.01.10 02:45:25</EXTRACT_TS> <REC_CNT>1</REC_CNT> <TASK> <TASK_INTERNAL_ID>5856</TASK_INTERNAL_ID> <TASK_ID>TASK-20151548-54546451</TASK_ID> </TASK> </TASK_EXTRACT> XSD File
<?xml version="1.0" encoding="UTF-8"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:simpleType name="DIType-decimal-10-0"> <xsd:restriction base="xsd:decimal"> <xsd:totalDigits value="10"/> <xsd:fractionDigits value="0"/> </xsd:restriction> </xsd:simpleType> <xsd:simpleType name="DIType-varchar-30"> <xsd:restriction base="xsd:string"> <xsd:maxLength value="30"/> </xsd:restriction> </xsd:simpleType> <xsd:element name="TASK_EXTRACT" > <xsd:complexType> <xsd:sequence minOccurs="0" maxOccurs="unbounded"> <xsd:element ref="EXTRACT_TS" /> <xsd:element ref="REC_CNT" /> <xsd:element ref="TASK" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="EXTRACT_TS" type = "xsd:dateTime"/> <xsd:element name="REC_CNT" type = "xsd:integer"/> <xsd:element name="TASK" > <xsd:complexType> <xsd:sequence> <xsd:element ref="TASK_INTERNAL_ID" /> <xsd:element ref="TASK_ID" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="TASK_INTERNAL_ID" type = "DIType-decimal-10-0"/> <xsd:element name="TASK_ID" type = "DIType-varchar-30"/> </xsd:schema>
No comments:
Post a Comment