XML data not read in SSIS

If NULL for all columns is returned then it probably means that the transformation is correct as far as the xml shape is concerned, but the casing of the node names does not match. For example:

declare @xml xml;

-- let it have 3 columns 4 rows shape
set @xml = '<rows>
    <row><Col1>A1</Col1><Col2>B1</Col2><Col3>C1</Col3></row>
    <row><Col1>A2</Col1><Col2>B2</Col2><Col3>C2</Col3></row>
    <row><Col1>A3</Col1><Col2>B3</Col2><Col3>C3</Col3></row>
    <row><Col1>A4</Col1><Col2>B4</Col2><Col3>C4</Col3></row>
</rows>';

-- select with shape correct, but casing wrong
-- correctly returns the desired number of columns
-- and rows, but all the values are NULL
select
    item.value('col1[1]', 'varchar(5)') Col1,
    item.value('col2[1]', 'varchar(5)') Col2,
    item.value('col3[1]', 'varchar(5)') Col3
    from @xml.nodes('rows/row') R(item);

 results:
Col1  Col2  Col3
----- ----- -----
NULL  NULL  NULL
NULL  NULL  NULL
NULL  NULL  NULL
NULL  NULL  NULL

-- lets fix the casing and see the results:
select
    item.value('Col1[1]', 'varchar(5)') Col1,
    item.value('Col2[1]', 'varchar(5)') Col2,
    item.value('Col3[1]', 'varchar(5)') Col3
    from @xml.nodes('rows/row') R(item);

-- correct results:
Col1  Col2  Col3
----- ----- -----
A1    B1    C1
A2    B2    C2
A3    B3    C3
A4    B4    C4

Please check the spelling of the nodes which actually hold desired values to make sure that each one is spelled correctly and the case matches the source.

Oleg