How to remove double quotes surrounding the text while importing a CSV file?

Further searching revealed that I should use the Text Qualifier on the General Tab of the Flat File Source.

Flat file content when viewed in a Notepad++. CRLF denotes that the lines end with Carriage Return and Line Feed.

Flat file in Notepad++

On the flat file connection manager, enter the double quotes in the Text qualifier text box.

General tab of the flat file connection manager

Once the text qualifier is set, the data would be parsed correctly and displayed as shown below:

Columns tab of the flat file connection manager

Related