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.
csv file from http://seanlahman.com/baseball-archive/statistics/
Yes, indeed this was fixed in SSMS 17.9. Enjoy! :-)
Looks like this was addressed in VS build number: 14.0.17285.0. Nice suggestion!