Hi,
I have a SSIS data flow task that uses an XML file that contains nested
nodes. How do I merge the data in all nodes to one output?, e.g.:
- <Switches>
- <HeaderFields>
<Date>20060808</Date>
<AccountNumber />123</AccountNumber>
<FromFund>A01</FromFund>
<Quantity>ALL</Quantity>
</HeaderFields>
- <LineItems>
- <LineItemRow>
<ToFund>A11</ToFund>
<QtyPercent>11</QtyPercent>
</LineItemRow>
- <LineItemRow>
<ToFund>A09</ToFund>
<QtyPercent>12</QtyPercent>
</LineItemRow>
- <LineItemRow>
<ToFund>A11</ToFund>
<QtyPercent>13</QtyPercent>
</LineItemRow>
</LineItems>
</Switches>

The XML Source Editor creates 3 outputs: HeaderFields, LineItemRow, and
LineItems. I can create separate outputs for each node, but cannot
figure out how to merge them into one output.

Is there a simple way of doing this? Would I tweak the generated XSD
to force all elements into one node or something?

Thank you,
Greg