• The Hierarchy design is correct as far as I can see.

    The Data type is the same in the connection manager and in the Data Conversion Transformation Editior.

    I'm looking for a full XML document.