Bulk insert 8000+ records open xml .net

 

How do i do a bulk insert for 8000+ records using open xml in .net  and sql server 2000 .

Should break the loop of the data table after some 500 records and generate a new data table for it and do a bulk insert.

Any ideas?

 

Thanks,

Anand.

 

 

 
...