SSIS: XML Source Defining XSD File

• Jason Messersmith

  SSC Eights!

  Points: 824

  More actions

  August 15, 2013 at 9:53 am

  #282092

  I'm having some trouble with the XSD generator, the file it generates doesnt really make a whole lot of sense. The output for the data source doesnt contain all the data.

  Here is the XML I am importing:

  <?xml version="1.0"?>

  <Item>

  <itemID>3</itemID>

  <systemSku readonly="true">210000000003</systemSku>

  <defaultCost currency="USD">0</defaultCost>

  <avgCost currency="USD">0</avgCost>

  <tax>true</tax>

  <archived>false</archived>

  <itemType>default</itemType>

  <description>PBJ Shirt</description>

  <modelYear>0</modelYear>

  <upc>07777777777</upc>

  <ean></ean>

  <customSku>074604</customSku>

  <manufacturerSku></manufacturerSku>

  <timeStamp>2013-08-06T21:59:26+00:00</timeStamp>

  <categoryID>5</categoryID>

  <taxClassID>0</taxClassID>

  <departmentID>0</departmentID>

  <itemMatrixID>0</itemMatrixID>

  <manufacturerID>0</manufacturerID>

  <seasonID>0</seasonID>

  <defaultVendorID>0</defaultVendorID>

  <Prices>

  <ItemPrice>

  <amount currency="USD">9</amount>

  <useType readonly="true">Default</useType>

  </ItemPrice>

  <ItemPrice>

  <amount currency="USD">8</amount>

  <useType readonly="true">MSRP</useType>

  </ItemPrice>

  </Prices>

  </Item>

  Here is the XSD that visual studio generated:

  <?xml version="1.0"?>

  <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

  <xs:element name="Item">

  <xs:complexType>

  <xs:sequence>

  <xs:element minOccurs="0" name="itemID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="systemSku">

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="xs:unsignedLong">

  <xs:attribute name="readonly" type="xs:boolean" use="optional" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element minOccurs="0" name="defaultCost">

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="xs:unsignedByte">

  <xs:attribute name="currency" type="xs:string" use="optional" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element minOccurs="0" name="avgCost">

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="xs:unsignedByte">

  <xs:attribute name="currency" type="xs:string" use="optional" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element minOccurs="0" name="tax" type="xs:boolean" />

  <xs:element minOccurs="0" name="archived" type="xs:boolean" />

  <xs:element minOccurs="0" name="itemType" type="xs:string" />

  <xs:element minOccurs="0" name="description" type="xs:string" />

  <xs:element minOccurs="0" name="modelYear" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="upc" type="xs:unsignedLong" />

  <xs:element minOccurs="0" name="ean" />

  <xs:element minOccurs="0" name="customSku" type="xs:unsignedInt" />

  <xs:element minOccurs="0" name="manufacturerSku" />

  <xs:element minOccurs="0" name="timeStamp" type="xs:dateTime" />

  <xs:element minOccurs="0" name="categoryID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="taxClassID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="departmentID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="itemMatrixID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="manufacturerID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="seasonID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="defaultVendorID" type="xs:unsignedByte" />

  <xs:element minOccurs="0" name="Prices">

  <xs:complexType>

  <xs:sequence>

  <xs:element minOccurs="0" maxOccurs="unbounded" name="ItemPrice">

  <xs:complexType>

  <xs:sequence>

  <xs:element minOccurs="0" name="amount">

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="xs:unsignedByte">

  <xs:attribute name="currency" type="xs:string" use="optional" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element minOccurs="0" name="useType">

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="xs:string">

  <xs:attribute name="readonly" type="xs:boolean" use="optional" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:schema>