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.
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.