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 any errors before you do the actualy import.