SSMS Flat File Import is not working for SSMS 18.1 upgrade
When upgrading SSMS 18.0 to 18.1, the Flat File Import is no longer importing csv, tab delimited or other delimited files.
- Open SSMS 18.1, select any database to import to.
- Right click | Task | Import Flat File
- When presented by the file browse of the Wizard, navigate to where the attached (test_csv.txt) and load
- The attached (flatfileimport_error.png) appears.
note: This looks to be happening in my machine, as a fresh install SSMS 18.1 instead of an update on a different machine works.
flatfileimporterror.png - screenshot of error
testcsv.txt - sample csv used
ssmssetuplogs.zip - https://www.dropbox.com/s/ukpboytpbzogu1x/SsmsSetuplogs.zip?dl=0
Please. upgrade to SSMS 18.2 which has the fix for this issue.
After uninstalling SSMS 18.1 and reinstall and not upgrade, this now is working. Will this bug id be opened until the fix? Or can I change the title (it looks like I can't) so that it will say "SSMS Flat File Import is not working after upgrading SSMS 18.0 to SSSM 18.1 to better reflect the actual bug?