SSMS was designed to make regular tasks of DBAs and developers easier. Wizards were built for many different tasks to guide users to a quicker solution. There was one area that remained frustrating: the simple task of importing a flat file (CSV or TXT file). This seemingly basic functionality was mired by a clumsy and irritating Import and Export Wizard, which often made the task of importing data more difficult rather than easier.
With SSMS 17.3 came some relief! The Import Flat File Wizard removes much of the earlier unnecessary complexities of importing flat files into SQL Server. The wizard can be found using a right-click on a desired database name, then under the menu Tasks, as shown in the following screenshot: ...
