It's not an issue with SQL Server.  It's an issue with a malformed .csv file.  If the field contents where enclosed in quotes, such as "some,value","another,value", then there are not problems with commas in the middle of a field.  Any time a file is read by any system your file would be a problem.