Bulk insert into Database

From: Baz (Baz-at_no-spam.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 16:31:15 -0400

Hi,

I am designing an application that needs to do the following on a daily
basis:
- Parse XML files & extract relevant information. The number of XML files is
in thousands...
- Write the extracted information to a database.

I was considering the use of Datasets for this application. However, aren't
Datasets more suited in situations where you select (query) some data from
the database & perform updates on it? Would Datasets be efficient in cases
where there is only one-way communication between the client & database
server, i.e., data only travels from the client to server & only bulk
inserts are performed.

If Datasets aren't the best way to approach this, could I get some
suggestions on how to design this? Would it be more efficient to extract
records into a flat file & write those to a database using a stored
procedure?

Any suggestions welcome.
thanks!

Relevant Pages