Maybe the bulk insert could work but you didn't tell the exact error message.
An alternative would be to read the CSV file "yourself" and issuing INSERT-commands.
For reading the CSV file I would suggest this solution:
A Fast CSV Reader[
^]
If you need a sample for how to do INSERTs, you'll find one here:
http://www.dotnetperls.com/sqlclient[
^]
You would do that in a loop for all records and you should wrap it into a transaction.
Submit an article or tip