title: Load XML by SSIS - DTD is prohibited in this XML document error
body: <p>Hope you all are doing well.</p>
  
  <p>Previously I asked a question <a href="https://stackoverflow.com/questions/3298834/import-website-xml-feed-to-sql-server">how to import a XML file to SQL Server</a> thanks to all you responses.</p>
  
  <p>As my source file come with heavy amount of data, I am trying to load by SSIS. Below are the steps I followed:</p>
  
  <ol>
  <li>Imported XML by BulkLoad to a XML type column</li>
  <li>Created XSD Schema out of that XML file in SQL Server</li>
  <li>Now in SSIS, used XML Source and provided the XML schema for mapping to OLEDB destination.</li>
  </ol>
  
  <p>But the execution failed saying </p>
  
  <blockquote>
    <p><em>"Error: 0xC02090E7 at Load XML, XML Source <a href="https://stackoverflow.com/questions/3298834/import-website-xml-feed-to-sql-server">1</a>: The component "XML Source"
    (1) was unable to read the XML data.
    DTD is prohibited in this XML
    document."</em></p>
  </blockquote>
  
  <p>BOL says SSIS doesn't support DTD, and there is no way we can avoid DTD in my source file.</p>
  
  <p>Please anyone help me to resolve this issue.</p>
  
  <p><strong>Here is my XML file:</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!DOCTYPE _line_feed [
  &lt;!ELEMENT FeedTime (#PCDATA)&gt;
  &lt;!ELEMENT lastContest (#PCDATA)&gt;
  &lt;!ELEMENT lastGame (#PCDATA)&gt;
  &lt;!ELEMENT contest_maximum (#PCDATA)&gt;
  &lt;!ELEMENT contestantnum (#PCDATA)&gt;
  &lt;!ELEMENT description (#PCDATA)&gt;
  &lt;!ELEMENT event (event_datetimeGMT, gamenumber, sporttype, league, contest_maximum?, description?, (participants |  periods | total)+)&gt;
  &lt;!ELEMENT event_datetimeGMT (#PCDATA)&gt;
  &lt;!ELEMENT gamenumber (#PCDATA)&gt;
  &lt;!ELEMENT league (#PCDATA)&gt;
  &lt;!ELEMENT odds (moneyline_value, to_base?)&gt;
  &lt;!ELEMENT over_adjust (#PCDATA)&gt;
  &lt;!ELEMENT participants (participant*)&gt;
  &lt;!ELEMENT participant (participant_name, contestantnum, rotnum, visiting_home_draw?, odds?, pitcher?)&gt;
  &lt;!ELEMENT participant_name (#PCDATA)&gt;
  &lt;!ELEMENT periods (period*)&gt;
  &lt;!ELEMENT period (period_number, period_description, periodcutoff_datetimeGMT, period_status, period_update, spread_maximum?, moneyline_maximum?, total_maximum?, moneyline?, spread?, total?)&gt;
  &lt;!ELEMENT period_number (#PCDATA)&gt;
  &lt;!ELEMENT period_description (#PCDATA)&gt;
  &lt;!ELEMENT period_status (#PCDATA)&gt;
  &lt;!ELEMENT period_update (#PCDATA)&gt;
  &lt;!ELEMENT periodcutoff_datetimeGMT (#PCDATA)&gt;
  &lt;!ELEMENT _line_feed (FeedTime, lastContest, lastGame, events)&gt;
  &lt;!ELEMENT events (event*)&gt;
  &lt;!ELEMENT pitcher (#PCDATA)&gt;
  &lt;!ELEMENT rotnum (#PCDATA)&gt;
  &lt;!ELEMENT sporttype (#PCDATA)&gt;
  &lt;!ELEMENT moneyline (moneyline_visiting, moneyline_home, moneyline_draw?)&gt;
  &lt;!ELEMENT moneyline_value (#PCDATA)&gt;
  &lt;!ELEMENT moneyline_visiting (#PCDATA)&gt;
  &lt;!ELEMENT moneyline_home (#PCDATA)&gt;
  &lt;!ELEMENT moneyline_draw (#PCDATA)&gt;
  &lt;!ELEMENT moneyline_maximum (#PCDATA)&gt;
  &lt;!ELEMENT spread (spread_visiting, spread_adjust_visiting, spread_home, spread_adjust_home)&gt;
  &lt;!ELEMENT spread_adjust_home (#PCDATA)&gt;
  &lt;!ELEMENT spread_adjust_visiting (#PCDATA)&gt;
  &lt;!ELEMENT spread_home (#PCDATA)&gt;
  &lt;!ELEMENT spread_maximum (#PCDATA)&gt;
  &lt;!ELEMENT spread_visiting (#PCDATA)&gt;
  &lt;!ELEMENT to_base (#PCDATA)&gt;
  &lt;!ELEMENT total (total_points, over_adjust?, under_adjust?, units?)&gt;
  &lt;!ELEMENT total_maximum (#PCDATA)&gt;
  &lt;!ELEMENT total_points (#PCDATA)&gt;
  &lt;!ELEMENT under_adjust (#PCDATA)&gt;
  &lt;!ELEMENT units (#PCDATA)&gt;
  &lt;!ELEMENT visiting_home_draw (#PCDATA)&gt;
  ]&gt;
  
  &lt;_line_feed&gt;
      &lt;FeedTime&gt;1279783821193&lt;/FeedTime&gt;
      &lt;lastContest&gt;4118567&lt;/lastContest&gt;
      &lt;lastGame&gt;58681915&lt;/lastGame&gt;
  &lt;events&gt;
  &lt;event&gt;
      &lt;event_datetimeGMT&gt;2010-07-22 20:05&lt;/event_datetimeGMT&gt;
      &lt;gamenumber&gt;174201668&lt;/gamenumber&gt;
      &lt;sporttype&gt;Tennis&lt;/sporttype&gt;
      &lt;league&gt;M Atlanta 16&lt;/league&gt;
      &lt;participants&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;A. Roddick&lt;/participant_name&gt;
              &lt;contestantnum&gt;4333&lt;/contestantnum&gt;
              &lt;rotnum&gt;4333&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Visiting&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;R. Ram&lt;/participant_name&gt;
              &lt;contestantnum&gt;4334&lt;/contestantnum&gt;
              &lt;rotnum&gt;4334&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Home&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
      &lt;/participants&gt;
      &lt;periods&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;I&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;1500&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;-1850&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;1290&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;2000&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;spread&gt;
                  &lt;spread_visiting&gt;-5.5&lt;/spread_visiting&gt;
                  &lt;spread_adjust_visiting&gt;-124&lt;/spread_adjust_visiting&gt;
                  &lt;spread_home&gt;5.5&lt;/spread_home&gt;
                  &lt;spread_adjust_home&gt;106&lt;/spread_adjust_home&gt;
              &lt;/spread&gt;
              &lt;total&gt;
                  &lt;total_points&gt;19.5&lt;/total_points&gt;
                  &lt;over_adjust&gt;113&lt;/over_adjust&gt;
                  &lt;under_adjust&gt;-132&lt;/under_adjust&gt;
              &lt;/total&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;1&lt;/period_number&gt;
              &lt;period_description&gt;1st Set&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;I&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;5000&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;250&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;5000&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;-675&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;497&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
      &lt;/periods&gt;
  &lt;/event&gt;
  &lt;event&gt;
      &lt;event_datetimeGMT&gt;2010-07-22 20:05&lt;/event_datetimeGMT&gt;
      &lt;gamenumber&gt;174263209&lt;/gamenumber&gt;
      &lt;sporttype&gt;Tennis&lt;/sporttype&gt;
      &lt;league&gt;M Atlanta 16&lt;/league&gt;
      &lt;participants&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;I. Marchenko&lt;/participant_name&gt;
              &lt;contestantnum&gt;4335&lt;/contestantnum&gt;
              &lt;rotnum&gt;4335&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Visiting&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;X. Malisse&lt;/participant_name&gt;
              &lt;contestantnum&gt;4336&lt;/contestantnum&gt;
              &lt;rotnum&gt;4336&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Home&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
      &lt;/participants&gt;
      &lt;periods&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;2000&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;139&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;-151&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;2000&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;spread&gt;
                  &lt;spread_visiting&gt;2&lt;/spread_visiting&gt;
                  &lt;spread_adjust_visiting&gt;100&lt;/spread_adjust_visiting&gt;
                  &lt;spread_home&gt;-2&lt;/spread_home&gt;
                  &lt;spread_adjust_home&gt;-117&lt;/spread_adjust_home&gt;
              &lt;/spread&gt;
              &lt;total&gt;
                  &lt;total_points&gt;22.5&lt;/total_points&gt;
                  &lt;over_adjust&gt;-108&lt;/over_adjust&gt;
                  &lt;under_adjust&gt;-108&lt;/under_adjust&gt;
              &lt;/total&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;1&lt;/period_number&gt;
              &lt;period_description&gt;1st Set&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 20:05&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;5000&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;500&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;5000&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;115&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;-134&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
      &lt;/periods&gt;
  &lt;/event&gt;
  &lt;event&gt;
      &lt;event_datetimeGMT&gt;2010-07-22 21:30&lt;/event_datetimeGMT&gt;
      &lt;gamenumber&gt;174271178&lt;/gamenumber&gt;
      &lt;sporttype&gt;Tennis&lt;/sporttype&gt;
      &lt;league&gt;M Atlanta 16&lt;/league&gt;
      &lt;participants&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;K. Andersoõn&lt;/participant_name&gt;
              &lt;contestantnum&gt;4341&lt;/contestantnum&gt;
              &lt;rotnum&gt;4341&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Visiting&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
          &lt;participant&gt;
              &lt;participant_name&gt;D. Young&lt;/participant_name&gt;
              &lt;contestantnum&gt;4342&lt;/contestantnum&gt;
              &lt;rotnum&gt;4342&lt;/rotnum&gt;
              &lt;visiting_home_draw&gt;Home&lt;/visiting_home_draw&gt;
          &lt;/participant&gt;
      &lt;/participants&gt;
      &lt;periods&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 21:30&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;2000&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;-148&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;136&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;0&lt;/period_number&gt;
              &lt;period_description&gt;Game&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 21:30&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;500&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;2000&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;500&lt;/total_maximum&gt;
              &lt;spread&gt;
                  &lt;spread_visiting&gt;-2&lt;/spread_visiting&gt;
                  &lt;spread_adjust_visiting&gt;-121&lt;/spread_adjust_visiting&gt;
                  &lt;spread_home&gt;2&lt;/spread_home&gt;
                  &lt;spread_adjust_home&gt;104&lt;/spread_adjust_home&gt;
              &lt;/spread&gt;
              &lt;total&gt;
                  &lt;total_points&gt;22.5&lt;/total_points&gt;
                  &lt;over_adjust&gt;-111&lt;/over_adjust&gt;
                  &lt;under_adjust&gt;-105&lt;/under_adjust&gt;
              &lt;/total&gt;
          &lt;/period&gt;
          &lt;period&gt;
              &lt;period_number&gt;1&lt;/period_number&gt;
              &lt;period_description&gt;1st Set&lt;/period_description&gt;
              &lt;periodcutoff_datetimeGMT&gt;2010-07-22 21:30&lt;/periodcutoff_datetimeGMT&gt;
              &lt;period_status&gt;O&lt;/period_status&gt;
              &lt;period_update&gt;open&lt;/period_update&gt;
              &lt;spread_maximum&gt;5000&lt;/spread_maximum&gt;
              &lt;moneyline_maximum&gt;500&lt;/moneyline_maximum&gt;
              &lt;total_maximum&gt;5000&lt;/total_maximum&gt;
              &lt;moneyline&gt;
                  &lt;moneyline_visiting&gt;-126&lt;/moneyline_visiting&gt;
                  &lt;moneyline_home&gt;108&lt;/moneyline_home&gt;
              &lt;/moneyline&gt;
          &lt;/period&gt;
      &lt;/periods&gt;
  &lt;/event&gt;
  
  ...
  ...
  
  &lt;/events&gt;
  &lt;/_line_feed&gt;
  </code></pre>
  
  <p><strong>XSD schema file used:</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"&gt;
    &lt;xs:element name="_line_feed"&gt;
      &lt;xs:complexType&gt;
        &lt;xs:sequence&gt;
          &lt;xs:element name="FeedTime" type="xs:unsignedLong" /&gt;
          &lt;xs:element name="lastContest" type="xs:unsignedInt" /&gt;
          &lt;xs:element name="lastGame" type="xs:unsignedInt" /&gt;
          &lt;xs:element name="events"&gt;
            &lt;xs:complexType&gt;
              &lt;xs:sequence&gt;
                &lt;xs:element maxOccurs="unbounded" name="event"&gt;
                  &lt;xs:complexType&gt;
                    &lt;xs:sequence&gt;
                      &lt;xs:element name="event_datetimeGMT" type="xs:string" /&gt;
                      &lt;xs:element name="gamenumber" type="xs:unsignedInt" /&gt;
                      &lt;xs:element name="sporttype" type="xs:string" /&gt;
                      &lt;xs:element name="league" type="xs:string" /&gt;
                      &lt;xs:element minOccurs="0" name="contest_maximum" type="xs:unsignedShort" /&gt;
                      &lt;xs:element minOccurs="0" name="description" type="xs:string" /&gt;
                      &lt;xs:element name="participants"&gt;
                        &lt;xs:complexType&gt;
                          &lt;xs:sequence&gt;
                            &lt;xs:element maxOccurs="unbounded" name="participant"&gt;
                              &lt;xs:complexType&gt;
                                &lt;xs:sequence&gt;
                                  &lt;xs:element name="participant_name" type="xs:string" /&gt;
                                  &lt;xs:element name="contestantnum" type="xs:unsignedInt" /&gt;
                                  &lt;xs:element name="rotnum" type="xs:unsignedShort" /&gt;
                                  &lt;xs:element minOccurs="0" name="odds"&gt;
                                    &lt;xs:complexType&gt;
                                      &lt;xs:sequence&gt;
                                        &lt;xs:element name="moneyline_value" type="xs:string" /&gt;
                                        &lt;xs:element name="to_base" type="xs:string" /&gt;
                                      &lt;/xs:sequence&gt;
                                    &lt;/xs:complexType&gt;
                                  &lt;/xs:element&gt;
                                  &lt;xs:element minOccurs="0" name="visiting_home_draw" type="xs:string" /&gt;
                                  &lt;xs:element minOccurs="0" name="pitcher" type="xs:string" /&gt;
                                &lt;/xs:sequence&gt;
                              &lt;/xs:complexType&gt;
                            &lt;/xs:element&gt;
                          &lt;/xs:sequence&gt;
                        &lt;/xs:complexType&gt;
                      &lt;/xs:element&gt;
                      &lt;xs:element minOccurs="0" name="total"&gt;
                        &lt;xs:complexType&gt;
                          &lt;xs:sequence&gt;
                            &lt;xs:element name="total_points" type="xs:decimal" /&gt;
                            &lt;xs:element name="units" type="xs:string" /&gt;
                          &lt;/xs:sequence&gt;
                        &lt;/xs:complexType&gt;
                      &lt;/xs:element&gt;
                      &lt;xs:element minOccurs="0" name="periods"&gt;
                        &lt;xs:complexType&gt;
                          &lt;xs:sequence minOccurs="0"&gt;
                            &lt;xs:element maxOccurs="unbounded" name="period"&gt;
                              &lt;xs:complexType&gt;
                                &lt;xs:sequence&gt;
                                  &lt;xs:element name="period_number" type="xs:unsignedByte" /&gt;
                                  &lt;xs:element name="period_description" type="xs:string" /&gt;
                                  &lt;xs:element name="periodcutoff_datetimeGMT" type="xs:string" /&gt;
                                  &lt;xs:element name="period_status" type="xs:string" /&gt;
                                  &lt;xs:element name="period_update" type="xs:string" /&gt;
                                  &lt;xs:element name="spread_maximum" type="xs:unsignedShort" /&gt;
                                  &lt;xs:element name="moneyline_maximum" type="xs:unsignedShort" /&gt;
                                  &lt;xs:element name="total_maximum" type="xs:unsignedShort" /&gt;
                                  &lt;xs:element minOccurs="0" name="moneyline"&gt;
                                    &lt;xs:complexType&gt;
                                      &lt;xs:sequence&gt;
                                        &lt;xs:element name="moneyline_visiting" type="xs:short" /&gt;
                                        &lt;xs:element name="moneyline_home" type="xs:short" /&gt;
                                        &lt;xs:element minOccurs="0" name="moneyline_draw" type="xs:unsignedShort" /&gt;
                                      &lt;/xs:sequence&gt;
                                    &lt;/xs:complexType&gt;
                                  &lt;/xs:element&gt;
                                  &lt;xs:element minOccurs="0" name="spread"&gt;
                                    &lt;xs:complexType&gt;
                                      &lt;xs:sequence&gt;
                                        &lt;xs:element name="spread_visiting" type="xs:decimal" /&gt;
                                        &lt;xs:element name="spread_adjust_visiting" type="xs:short" /&gt;
                                        &lt;xs:element name="spread_home" type="xs:decimal" /&gt;
                                        &lt;xs:element name="spread_adjust_home" type="xs:short" /&gt;
                                      &lt;/xs:sequence&gt;
                                    &lt;/xs:complexType&gt;
                                  &lt;/xs:element&gt;
                                  &lt;xs:element minOccurs="0" name="total"&gt;
                                    &lt;xs:complexType&gt;
                                      &lt;xs:sequence&gt;
                                        &lt;xs:element name="total_points" type="xs:decimal" /&gt;
                                        &lt;xs:element name="over_adjust" type="xs:short" /&gt;
                                        &lt;xs:element name="under_adjust" type="xs:short" /&gt;
                                      &lt;/xs:sequence&gt;
                                    &lt;/xs:complexType&gt;
                                  &lt;/xs:element&gt;
                                &lt;/xs:sequence&gt;
                              &lt;/xs:complexType&gt;
                            &lt;/xs:element&gt;
                          &lt;/xs:sequence&gt;
                        &lt;/xs:complexType&gt;
                      &lt;/xs:element&gt;
                    &lt;/xs:sequence&gt;
                  &lt;/xs:complexType&gt;
                &lt;/xs:element&gt;
              &lt;/xs:sequence&gt;
            &lt;/xs:complexType&gt;
          &lt;/xs:element&gt;
        &lt;/xs:sequence&gt;
      &lt;/xs:complexType&gt;
    &lt;/xs:element&gt;
  &lt;/xs:schema&gt;
  </code></pre>
  
  <p>Awaiting your kind response. Also let me know if need some other details to understand the scenario.</p>
  
  <p>Thanks,
  Prashant</p>