XML Data gets truncated

As described in this thread I'm now able to read an RSS feed with the XML Source. I'm using the following XSD defininition in my source (it was created in the dialog from SSIS/XML Source):

< xml version="1.0" >
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="rss">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" name="channel">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" name="title" type="xs:string" />
              <xs:element minOccurs="0" name="link" type="xs:string" />
              <xs:element minOccurs="0" name="description" type="xs:string" />
              <xs:element minOccurs="0" name="language" type="xs:string" />
              <xs:element minOccurs="0" name="pubDate" type="xs:string" />
              <xs:element minOccurs="0" name="lastBuildDate" type="xs:string" />
              <xs:element minOccurs="0" name="docs" type="xs:string" />
              <xs:element minOccurs="0" maxOccurs="unbounded" name="item">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element minOccurs="0" name="id" type="xs:unsignedShort" />
                    <xs:element minOccurs="0" name="title" type="xs:string" />
                    <xs:element minOccurs="0" name="link" type="xs:string" />
                    <xs:element minOccurs="0" name="description" type="xs:string" />
                    <xs:element minOccurs="0" name="pubDate" type="xs:string" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
      <xs:attribute name="version" type="xs:decimal" use="optional" />
    </xs:complexType>
</xs:element>
</xs:schema>

If I make a double click on the green line coming out of my pane I see in the MetaData section

'Name''Data Type''Precision''Scale''Length''Code Page''Sort Key Position''Comparison Flags''Source Component'
'id''DT_UI2''0''0''0''0''0''''XML Source'
'title''DT_WSTR''0''0''255''0''0''''XML Source'
'link''DT_WSTR''0''0''255''0''0''''XML Source'
'description''DT_WSTR''0''0''255''0''0''''XML Source'
'pubDate''DT_WSTR''0''0''255''0''0''''XML Source'
'channel_Id''DT_UI8''0''0''0''0''0''''XML Source'

The colum 'description' is DT_WSTR and the length is 255. As my feed has more than 255 chars in this node I get an truncation error.

Is there a way to change the type of the field 'description' to 500 chars

Best Regards,
Dirk

Answer this question

XML Data gets truncated

JonathanSt

Yes, the default length is 255 for string.
Right click on XMLSrc and choose to bring out the advanced editor, there from "Input and Output Properties", find the output column "description", change the length to 500 and you'll be fine.

Thanks
XML Data gets truncated

Answer this question