Import XML using SSIS

See more:

SSIS

Hi,
I need a help here....

need to import xml file using SSIS package.

Each of the banking centers has multiple users. and the data should split here into 2 tables (sql server is the database)
banking centers should go to table1 and users to table2.
I can read a simple XML file with 3 columns (Fst_name, Lst_name, Age) and load onto one table. but here it has to go into two tables.
this requirement is very urgent, please help me out on this.

below is the sample file

<BankingCenters>
<BankingCenter>
<BankingCenterID>14213</BankingCenterID>
<BankingCenterName>West End</BankingCenterName>
<AddressLine1>880 Main Street</AddressLine1>
<AddressLine2>80581</AddressLine2>
<City>Waltham</City>
<State>MA</State>
<ZipCode>02451</ZipCode>
<AssociatesInfo>
<AssociateInfo>
<FRST_NM>ANA I</FRST_NM>
<LST_NM>Kary</LST_NM>
</AssociateInfo>
<AssociateInfo>
<FRST_NM>ANA II</FRST_NM>
<LST_NM>Lou</LST_NM>
</AssociateInfo>
</AssociatesInfo>
</BankingCenter>
<BankingCenter>
<BankingCenterID>14210</BankingCenterID>
<BankingCenterName>East End</BankingCenterName>
<AddressLine1>4212 wood dr</AddressLine1>
<AddressLine2></AddressLine2>
<City>lakemary</City>
<State>FL</State>
<ZipCode>32709</ZipCode>
<AssociatesInfo>
<AssociateInfo>
<FRST_NM>Andy</FRST_NM>
<LST_NM>Miller</LST_NM>
</AssociateInfo>
<AssociateInfo>
<FRST_NM>Joe</FRST_NM>
<LST_NM>Robert</LST_NM>
</AssociateInfo>
</AssociatesInfo>
</BankingCenter>
</BankingCenters>

thanks
Arun