loading data from file to db

  • Thread starter Thread starter AVL
  • Start date Start date
A

AVL

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?
 
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").
 
Yes, I need to validate data before uploading

sloan said:
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").
Click to expand...
 
Back
Top