Load a single Table from a xml file with multiple Hierarchy(Loop)

[abhi90]

Hi All,

We have a xml File which have 3 Hierarchies.I need to loop all 3 hierarchies and load it into a single Table using One Job. Can anybody please suggest how to achieve this. We have currently loading 3 hierarchies in 3 Different Tables using 3 Different Subjobs.

[abhi90]

Can anyone help with this please? @rhall? @shong?

[abhi90]

Can anyone help with this please

[vboppudi]

Hi Abhi90,

Is it possible to provide some sample data?

Regards,