Hello everyone,

I have the next problem:
1. one big xml (arround 150 mbs) with a lots of nodes in it

2. one sql server 2008 (or 2005, cause servers are not the same) with a table created from more fields from diferent nodes from the big xml


I want to create some sort of dataset or datatable from the xml that match the design of the sql table and then insert or update the sql table to match the xml

ex: the sql table has like 6 colums, x1 to x6

in the xml, x1, x2 and x3 are in the node Y
x4 in the node Z
and x5 and x6 in the node W

so far, i have been doing this:
- create a treeview from the xml and when clicked on a node, it load the content in a datagridview, that can be imported into sql

can anyone give me a clue about how this job can be done without stressing the server to much ?

PS; must say when importing about 45000 rows, i get a timeout error!

TY