SSIS: Getting parent row field in sub-row output in XML Source

See more:

XML

SSIS

XSD

Hi Friends,

I have an SSIS Package which reads XML file using XML Source Component.
This XML File has two outputs. One is for "Invoice" and other is for "InvoiceDetail"
The structure of the XML File is like this.

<my:myFields>
<my:group1>
        <my:Invoice>
            <my:field1>1</my:field1>
            <my:field2>2014-11-11</my:field2>
            <my:field3>33370</my:field3>
            <my:Group2>
                <my:InvoiceDetail>

                    <my:Sub6 xsi:nil="true">100</my:Sub6>
                    <my:Sub7 xsi:nil="true">Charges</my:Sub7>
                    <my:Sub8>140</my:Sub8>
                    <my:Sub9 xsi:nil="true">78</my:Sub9>
                    <my:Sub10 xsi:nil="true">0</my:Sub10>
                    <my:Sub12>0</my:Sub12>
                </my:InvoiceDetail>
            </my:Group2>
            <my:field18></my:field18>
        </my:Invoice>
</my:group1>
</my:myFields>

I can get all fields of Invoice and InvoiceDetail in seperate outputs. But, I cannot join these rows since InvoiceDetail doesn't have the ID (field1) which links to the Invoice. Is there any idea to get the InvoiceID field also with the InvoiceDetail output ?

(Please don't ask me to add an ID in sub-rows too.. This file comes from another retailer using InfoPath.)

Thanks