I am SQL Developer and new to C# programming. Got a chance to learn C# to accomplish a task. Here it is-

I have about 5000 complex XML files needo extract the fileds and load into SQL Server 2008R2. I tried it to do it in my area(SQL & SSIS) but not achieved because of complex in structure. XML sourece in SSIS can't handle the files. My lead suggested me to do using VB or C# coding. Fileds i need are not under same node and Path in all files.

Can anyone please tell me how to extract data from XML and store into SQL. Any material/links to get overview about classes and methods related to XML and SQl are appreciated.

Thanks in Advance!
Kumar