If you're using SQL 2005, you may use CLR and have a Regular Expressions to parse the csv string.

Assuming the csv record is less than 8K you may import the...