Hi,

I need a help here....

I need to import xml file using SSIS package (attached sample xml file).
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 xml 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