Uploading file raw data into DB

[Guest]

What is the best way (regarding the performance) to upload file lines to a table in DB

Running SP for each line or smth else..

Thanks

 

[William \(Bill\) Vaughn]

BCP or DTS.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

 

[Guest]

.... and if I have to do some checks on each line
is there any way to store all the raw data (and some other corresponding data) in some intermediate object (dataset?), and then upload it to the table by one move
running SP n-times doesn't sound good

Thanks.

 

[William \(Bill\) Vaughn]

ADO won't help here unless you roll your own UPDATE statements in a batch
and execute the batch yourself.
I still think DTS (which can do some manipulation too) would be a better
approach. You can read the data from the source (or generate it), write to a
delimited file and then get DTS to upload it. Yes, round-trip scenarios are
going to be very slow.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

... and if I have to do some checks on each line ?
is there any way to store all the raw data (and some other corresponding

data) in some intermediate object (dataset?), and then upload it to the
table by one move?