loading data from file to db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AVL - 08 Feb 2008 13:31 GMT

Hi,
I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

which is the best approach to load the daat wrt performance...

as of now, i'm planning to populate into a dataset and loop through the
dataset
record by record and update into the db..is there any other alternative?

Reply to this Message

sloan - 08 Feb 2008 13:37 GMT

Do you need to run any rules on the data BEFORE insert?

Or is it a "dumb" insert? (Copy no matter what, the source data is
"perfect").

> Hi,
> I've a requirement to load the data froma csv file to sql server table
[quoted text clipped - 6 lines]
> dataset
> record by record and update into the db..is there any other alternative?

Reply to this Message

AVL - 12 Feb 2008 11:47 GMT

Yes, I need to validate data before uploading

> Do you need to run any rules on the data BEFORE insert?
>
[quoted text clipped - 11 lines]
> > dataset
> > record by record and update into the db..is there any other alternative?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...