Embedded Text Qualifiers in CSV Files

I encountered an issue where double quotes inside a CSV field were escaped by a backslash, resulting in a SQL Server Integration Services package not being able to read it.

Here's what it looks like:

"previous column",""quoted text escaped with backslash" more text","next column"

Am I wrong in thinking that the CSV standard calls for double quotes inside a field to be escaped by another double quote? Reference - http://tools.ietf.org/html/rfc4180

Here's what the same field would look like if escaped by double quotes:

"previous column","""quoted text escaped with double quotes"" more text","next column"

I tested this format successfully in SQL Server Integration Services.

Thank you,

Chris Koester
Sr. Business Intelligence Developer, Data Platform & Analytics
[email protected]
linkedin.com/in/chriskoester