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

SSMS 17.3 Flat File Import doesnt allow changing destination table when table is already existing

SSMS 17.3 (14.0.17199.0)

The Flat File Import Wizard doesn't allow changing a destination table when that table is already existing once the Wizard runs and encounters an error. Since the tool is simplistic as to not provide a way to override (ie drop if existing destination table ), it's annoying to :

1. drop the first table created
2. close the Wizard and do it all over again, either with a new table or the same name previously assuming it was removed already.

Here's a screen capture recording if attachment hasn't shown up yet.
http://g.recordit.co/YMor8lw4nx.gif

csv file from http://seanlahman.com/baseball-archive/statistics/

0 votes
Sign in
(thinking…)
Sign in with: Microsoft
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…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • jdor commented  ·   ·  Flag as inappropriate

    Looks like this was addressed in VS build number: 14.0.17285.0. Nice suggestion!

Feedback and Knowledge Base