I have large TEXT files (less than 50MB) that I want to load into
MSSQL. Each line has to be extracted, parsed and then inserted into the
DB. What's the best way of doing this?
Currently I extract each line, parse it and then INSERT it into the DB.
I am not using any DataSet/DataGrids. I have one db connection always
open for this process. The problem is that this takes almost half an
hour to finish. I'm wondering if using a DataSet would be beneficial
for me.
Any help would be appreciated!