Hi,
My requirement is to read a CSV file which has around 40,000 records and insert into DB.
I have the CSV read and stored in a collection object which is passed to the Webservice.
My client doesn't want to do abulk insert of all the records and wants to insert 1000 records at a time.
what would be the best way to do that?
1. Pass the entore colelction object to the webservice and the pass a xml stream from webservice to SQl and do a split in sql server and insert.
2. Pass 1000 records at a time from the application to the webservice and bulk insert.
Expecting replies ASAP.
thanks for ur help.
My requirement is to read a CSV file which has around 40,000 records and insert into DB.
I have the CSV read and stored in a collection object which is passed to the Webservice.
My client doesn't want to do abulk insert of all the records and wants to insert 1000 records at a time.
what would be the best way to do that?
1. Pass the entore colelction object to the webservice and the pass a xml stream from webservice to SQl and do a split in sql server and insert.
2. Pass 1000 records at a time from the application to the webservice and bulk insert.
Expecting replies ASAP.
thanks for ur help.
Comment