Thanks Steven Willis

I have another questions. if my XML files contain so many Node around 100. i need to load into more then 100 tables and each table contain more then 150 field so in this situation.i need check the each node and like <Contact>,<Sub> and load the data into the staging tables.

I am not sure how i will do that without hardcoding every thing.

Please give me some idea how i will do this.

Thansk a lot for your help.