Need help creating xsd for non-standard xml

• latch.jon

  SSC Rookie

  Points: 36

  More actions

  March 23, 2011 at 11:51 am

  #248625

  The SSIS xsd generator creates an incorrect xsd for this xml:

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

  - <File>

  - <Row>

  <Column Name="JobID">2010-1022</Column>

  <Column Name="Folder">Closed (Filled)</Column>

  <Column Name="NumberofOpenings">1</Column>

  <Column Name="NumberofOpeningsRemaining">0</Column>

  <Column Name="BusinessCardTitle">Director of Operations</Column>

  </Row>

  </File>

  Any help creating a valid xsd file for the above xml would be GREATLY appreciated...JON

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  March 23, 2011 at 11:59 am

  #1302645

  Please do not double-post. Direct comments here: http://www.sqlservercentral.com/Forums/Topic1082871-21-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• latch.jon

  SSC Rookie

  Points: 36

  More actions

  March 23, 2011 at 12:07 pm

  #1302649

  Sorry about that!

  Wasn't sure if the same people would be monitoring both forum topics...