This article addresses all the improvements that have been made in SSMS’s Import Wizard and how they can be used for efficiency.
SQL Server Management Studio aka SMSS is used for multiple purposes like managing, administrating, accessing, configuring and developing all components of any SQL application like Azure SQL Database, SQL Data Warehouse, and SQL Server.
Recently, the 17.3 SMSS was released, and today we are going to talk about how its Import Wizard has improved. The company has made some significant changes to its Import Flat File Wizard. Apparently, this new Import Flat File Wizard promises to make importing file to SQL Server simpler and hassle-free.
SMSS 2017 Flat File Import Setting
Import Flat File Wizard has been designed to streamline the process of importing flat file in an intelligent framework while using specialized knowledge and requiring next to minimal amount of user intervention. This new option is much more intelligent, automotive, and spontaneous which helps the user in importing files without much effort or involvement.
Steps to use a Flat File Wizard in SMSS
High Level Steps – Specify Input File > Preview Data > Modify Schema > Summary > Results.
Step 1: The user needs to launch the wizard in SSMS, for which he/she needs to click on the database file then Tasks and then click on the Import Flat File Wizard.
This Import Flat File Page also consists of a brief description of the page.
Step 2: Click Next > Now the user needs to specify the location where he/she wants to import their file, while also specifying a unique table name for the file that is being imported.
Step 3: Once the users set up the location of the Flat File, it will automatically generate a Flat Filename. If the user chooses to preview his or her data, he/she can go to the next screen and preview their data. While using this option, the data is corrected automatically where quotes are removed. This prevents the user from wasting his/her time in making configuration changes to import it.
Step 4: Click next and go to Modify Columns. The wizard has been improved to become intelligent to identify and perform, and make predictive file splits. It also scans the data to predict data type for column values.
This screen also allows users to set up column properties like Data Type, Name, and Primary Key etc. Users can access the complete list of column types using its drop down settings. Users can also set up different data type according to their requirement.
Step 5: After selecting the column types, the user can look at the task settings on the Next Screen.
Step 6: Now select next to initiate the import.
Step 7: Congratulations! Your file has been imported. Make sure to check your newly created table with all the data types.
Errors with Flat File Wizard
New files should have a unique table name if a similar file already exists then the document will return with an error saying “Provided Table Name already exists”.
A user then needs to be assigned with permissions to create new tables. However do not confuse such errors with data errors which need a specialized tool that can repair corrupt SQL Server database to address the situation.
Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com