XML Partitioning

  • Thread starter Thread starter polur.venkat
  • Start date Start date
P

polur.venkat

hi,
i have a problem ,
I have a database which inserts bulk of data onto the sql and oracle
database from excel sheets ,

I was juss planning to create threadpools and activate multiple threads
to insert data onto the database from the excel.

i am thinking of creating a XML sheet for which first gets inserted
from excel sheet and and from there use XML sheet to insert onto the
database as we can never work efficiently with excel as with XML,

Now i need to know...how can i partition a XML sheet , i mean i need to
create 3 or more threads for a single process which partitions the
process as 1st half and 2nd half and excutes two threads simultaneusly,

I ll appreciate if u guys can help me in this

Thanks
Mahesh Manas
 
You could have picked a slower way to move the data... but I don't know how.
Check out BCP or DTS. It can move data from any source to SQL Server and
Oracle.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top