xmltextreader

  • Thread starter Thread starter sqlnovice
  • Start date Start date
S

sqlnovice

I have a very big xml file with around 300 records of data. I have to load
the data into table. I have been told to use xmltextreader as is fast and
does not store data in memory. but i have a problem. in my xml file I have
nested loop. for ex:
<test>
<name> testing </name>
<departments>
<depname> IT </depname>
<deploc> Chicago </deploc>
</departments>
<Address> 123 </Address>
<title> developer </title>
</test>
I have to load departments in a different table and rest of it in a
different database table. Any suggestions is greately appreciated.
 
Thanks peter for your respones! Can you give me sample code to start on it as
I'm new to xml world.
 
Back
Top