SSIS XMLSource only sees null values ​​in an XML variable

Question

I have a data stream task with an XMLSource that references an XML variable. The DataFlow task recognizes that the variable has the number of rows, but in each row they see only zero values:

Xml variable value:

<?xml version="1.0" encoding="utf-8"?>
<words>
   <word>butter</word>
   <word>crispy</word>
</words>

I used this source to create the XSD in the XMLSource editor - here is the XSD autogenerator:

<?xml version="1.0"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="words">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="word" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

The package compiles, executes and processes all the lines in my XML, but it only sees zeros, not the actual text lines ... Here is a snapshot of the DataViewer showing 2 lines after reading the XML variable:

Answer 1

, ... , , - . " ", , "".

, XML node:

<?xml version="1.0" encoding="utf-8"?>
<datarows>
   <words>
      <word>bacon</word>
      <word>roasted</word>
      <word>pork</word>
      <word>edamame</word>
   </words>
</datarows>

, XML, , , SSIS , root node, datarows. , word .

:

<?xml version="1.0"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="datarows">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="1" name="words">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="word" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

Answer 2

. - xml sql 2008.

, , xml -. , , 1. -
2. script, .
3. " XMl" .

-Kris...