Hi

I get file having size around 70-80 mbs in the text format containing records on the daily basis. I want to save all the records in sql server database to the existing table and perform some calculations and restore them

I am looking for a way to automate the copying file to server and calculation part. I am considering to make a windows process in .net for this purpose.

Is there any better way to do the job?

Avats

The quickest way to get that much data into SQL Server on a daily basis is to use the bulk copy program in SQL Server. Look for bcp in the index of the SQL Server Books Online for more information about this program.

It sounds like you may want to bulk copy the data into a temp table in SQL Server and then use a stored procedure to process the records in the temp table, performing your calculations, and then insert those records into your permanent table.

Thearon