How Import/Export extended characters and newlines to/from csv/tab delimited?
As far as I can figure out, you would have to convert char(10) and char(13) to something else, and then do an UPDATE after importing them back into SQL Server, to replace the converted characters back into char(10) and char(13). By definition, I don’t see any way a CSV file could contain a carriage return or linefeed in the data, as that would indicate an end of line and probably raise some kind of error when you tried to import the CSV file into another application (or back into SQL Server.