If you want to eliminate locks for a select statment have a look at NOLOCK.

I also think making a query ReadOnly will prevent locking of the base table.

Make sure you are...

You might want to considder using BCP to grab each line of the file into a single column.

if you do thst you can parse the CSV first to sort out...