Copy Data, Complex XMLs (with different structures) into SQL

Hello.

I need to load multiple XMLs daily. The XMLs come in different structures: an element can be presented multiple times in a file , and each tag will then be postfixed with a sequencial number, example:

File 1 can have only on representation in the role_entity element, while another XML files will have more role_entity elements

File 1

<cbm_contract_role_entity0000000001>

....

</cbm_contract_role_entity0000000001>

and file x would multiple representation of the role_entity elements, and unfortunately the number of role entity differ from a file to another.

File X

<cbm_contract_role_entity0000000001>

....

</cbm_contract_role_entity0000000001>

<cbm_contract_role_entity0000000002>

....

</cbm_contract_role_entity0000000002>

<cbm_contract_role_entity0000000003>

....

</cbm_contract_role_entity0000000003>

How can I, in a foreach, and using copy data (or any other activity) can I copy the content of these XMLs into SQL.

Thanks

Mody