SSMS 17.3 Import Flat File doesn't import correctly quoted fields which contain double-quoted characters
New Import Flat File Functionality cannot import properly quoted string values which contains escaped double-quoted characters. CSV file specification allows such notation
1, "New functionality: ""Flat File Import"""
We expect this be fixed in the next major release of SSMS.
Dylan Taft commented
Same with output - would expect SSIS to be able to escape input\output flat files based on user definitions in connection mgr. Convention is to escape with double quote
Ie te"st becomes "te""st" on CSV output