title: Importing csv file into SQL Server using SSIS with multiple double quotes in data
body: <p>I have an issue occurring due to a very specific situation when trying to import a csv file into an SQL Server table using a SSIS package.  The data in the csv file can contain double quotes and commas.  As such, data with commas are double quoted and double quotes are escaped with an additional double quote.  I've used the text qualifier to successfully process the initial surrounding quotes.  However, there are particular instances where data is formatted like <strong>"""Anne"", Annabelle"</strong> which I cannot get to process.  The extra double quotes in the data appear to cause the comma to terminate the field. I have tried to use the Derived Column Transformation to replace those double quotes with something else that might not cause the issue, but to no avail.  Has anyone else encountered this issue and found a solution or workaround?</p>