A little perplexed by XML Source

• rsteckly

  Say Hey Kid

  Points: 664

  More actions

  November 26, 2009 at 2:39 pm

  #135606

  Hi,

  I'm trying to build a package that reads in an XML file and copies it to a relational structure.

  Its probably a dumb question, but I'm a little perplexed by the XML Source menu. I have the XML file and a generated XSD schema. The XML file is from an Endnote library. Here is an example of it:

  <?xml version="1.0" encoding="UTF-8" ?>

  <xml>

  <records>

  <record>

  <database name="My EndNote Library.enl" path="C:\Users\rsteckly\Documents\My EndNote Library.enl">My EndNote Library.enl</database>

  <source-app name="EndNote" version="13.0">EndNote</source-app><rec-number>1</rec-number><foreign-keys><key app="EN" db-id="5xzpd955jparp1e5xaeppvt9s9p2f0aefxev">1</key></foreign-keys><ref-type name="Book">6</ref-type><contributors><authors><author><style face="normal" font="default" size="100%">P.G. Wodehouse</style></author></authors><secondary-authors><author><style face="normal" font="default" size="100%">1</style></author></secondary-authors><subsidiary-authors><author><style face="normal" font="default" size="100%">1</style></author></subsidiary-authors><translated-authors><author><style face="normal" font="default" size="100%">1</style></author></translated-authors></contributors><auth-address><style face="normal" font="default" size="100%">1</style></auth-address><titles><title><style face="normal" font="default" size="100%">The World of Mr. Psmith</style></title><secondary-title><style face="normal" font="default" size="100%">1</style></secondary-title><alt-title><style face="normal" font="default" size="100%">1</style></alt-title><short-title><style face="normal" font="default" size="100%">1</style></short-title><translated-title><style face="normal" font="default" size="100%">1</style></translated-title></titles><pages><style face="normal" font="default" size="100%">1</style></pages><volume><style face="normal" font="default" size="100%">1</style></volume><number><style face="normal" font="default" size="100%">1</style></number><num-vols><style face="normal" font="default" size="100%">1</style></num-vols><edition><style face="normal" font="default" size="100%">1</style></edition><section><style face="normal" font="default" size="100%">1</style></section><reprint-edition><style face="normal" font="default" size="100%">1</style></reprint-edition><keywords><keyword><style face="normal" font="default" size="100%">1</style></keyword></keywords><dates><year><style face="normal" font="default" size="100%">1992</style></year><pub-dates><date><style face="normal" font="default" size="100%">1</style></date></pub-dates></dates><pub-location><style face="normal" font="default" size="100%">1</style></pub-location><publisher><style face="normal" font="default" size="100%">1</style></publisher><orig-pub><style face="normal" font="default" size="100%">1</style></orig-pub><isbn><style face="normal" font="default" size="100%">1</style></isbn><accession-num><style face="normal" font="default" size="100%">1</style></accession-num><call-num><style face="normal" font="default" size="100%">1</style></call-num><abstract><style face="normal" font="default" size="100%">1</style></abstract><label><style face="normal" font="default" size="100%">1</style></label><caption><style face="normal" font="default" size="100%">1</style></caption><notes><style face="normal" font="default" size="100%">1</style></notes><work-type><style face="normal" font="default" size="100%">1</style></work-type><urls><related-urls><url><style face="normal" font="default" size="100%">1</style></url></related-urls></urls><electronic-resource-num><style face="normal" font="default" size="100%">1</style></electronic-resource-num><remote-database-name><style face="normal" font="default" size="100%">1</style></remote-database-name><remote-database-provider><style face="normal" font="default" size="100%">1</style></remote-database-provider><research-notes><style face="normal" font="default" size="100%">1</style></research-notes><language><style face="normal" font="default" size="100%">1</style></language><access-date><style face="normal" font="default" size="100%">1</style></access-date></record></records></xml>

  When I go into the XML Source menu, each one of these tags is its own entry. When I choose "Record," which should contain all the other tags/fields, all it has is "rec-number," rec-id, etc. Am I missing something?

  Here's the XSD file:

  <?xml version="1.0" encoding="utf-8"?>

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

  <xs:element name="xml">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="records">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="record">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="database">

  <xs:complexType>

  <xs:simpleContent>

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

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

  <xs:attribute name="path" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element name="source-app">

  <xs:complexType>

  <xs:simpleContent>

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

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

  <xs:attribute name="version" type="xs:decimal" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element name="rec-number" type="xs:unsignedByte" />

  <xs:element name="foreign-keys">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="key">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="app" type="xs:string" use="required" />

  <xs:attribute name="db-id" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="ref-type">

  <xs:complexType>

  <xs:simpleContent>

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

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

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:element name="contributors">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="authors">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="author">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="secondary-authors">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="author">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="subsidiary-authors">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="author">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="translated-authors">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="author">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </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:element name="auth-address">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="titles">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="title">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="secondary-title">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="alt-title">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="short-title">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="translated-title">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="pages">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="volume">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="number">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="num-vols">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="edition">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="section">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="reprint-edition">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="keywords">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="keyword">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="dates">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="year">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="pub-dates">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="date">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </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:element name="pub-location">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="publisher">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="orig-pub">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="isbn">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="accession-num">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="call-num">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="abstract">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="label">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="caption">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="notes">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="work-type">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="urls">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="related-urls">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="url">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </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:element name="electronic-resource-num">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="remote-database-name">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="remote-database-provider">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="research-notes">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="language">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  <xs:element name="access-date">

  <xs:complexType>

  <xs:sequence>

  <xs:element name="style">

  <xs:complexType>

  <xs:simpleContent>

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

  <xs:attribute name="face" type="xs:string" use="required" />

  <xs:attribute name="font" type="xs:string" use="required" />

  <xs:attribute name="size" type="xs:string" use="required" />

  </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:sequence>

  </xs:complexType>

  </xs:element>

  </xs:schema>

• Fozzie

  SSCrazy

  Points: 2168

  More actions

  December 2, 2009 at 8:12 am

  #1086523

  It's probably down to the complexity of the xml file. It's treating lower segments like children, or sub-tables as there could be many possible values for that part of the element.

  For instance foreign key element could have more than one key child. The data naturally doesn't seem to fit into a single row.

  With the XML component you should be able to use connect to multiple sources. With that you may be able to merge the data together in how you think it should look?

  Sorry don't know enough to help further. I've had enough issues myself with the xsd. :blink:

  Oh the way to specify the length of the string of an element and not get those annoying 255 character warning messages is from something like this:

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

  <xs:complexType>

  <xs:simpleContent>

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

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

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

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  is to do something this:

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

  <xs:complexType>

  <xs:simpleContent>

  <xs:extension base="databaseType">

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

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

  </xs:extension>

  </xs:simpleContent>

  </xs:complexType>

  </xs:element>

  <xs:simpleType name="databaseType">

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

  <xs:maxLength value="64" />

  <xs:minLength value="0" />

  </xs:restriction>

  </xs:simpleType>

  Then SSIS should get the correct data lengths for the text. There's probably better ways...