XML : SSIS 2008 can read the xml file but does not write into SQL server table

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