Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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
ID, Value
1, "New functionality: ""Flat File Import"""

2 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Dylan Taft commented  ·   ·  Flag as inappropriate

    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

Feedback and Knowledge Base