Uploading file raw data into DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkG - 30 Mar 2004 11:01 GMT

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

Reply to this Message

William \(Bill\) Vaughn - 30 Mar 2004 19:15 GMT

BCP or DTS.

Signature

____________________________________
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.
__________________________________

> 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

Reply to this Message

Mark G - 30 Mar 2004 23:56 GMT

... 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.

Reply to this Message

William \(Bill\) Vaughn - 31 Mar 2004 19:01 GMT

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

Signature

> ... 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.

Reply to this Message

Uploading file raw data into DB

Free Magazines