Import Flat File Wizard in SSMS 17.3


Couple of days back on 10th October, the Microsoft SQL Server Team announced the release of the next version of SQL Server Management Studio 17.3. I downloaded the latest version and started playing around with the new features. One thing which I was interested to check out was the new ‘Import Flat File‘ wizard which promises to improve/simplify the import experience of flat files to SQL Server.

SSMS 17.3

Once you right click on your database, go to Tasks and then select ‘Import Flat File‘ to open the new wizard —

Task Database

The wizard has step by step details to guide you through the data import process —

Import Flat File

The high level steps which the wizard performs to import the file contents into a new table in your database are —

Specify Input File
Preview Data
Modify Schema
Summary
Results

The below link has step by step tutorial to guide you through the ‘Import Flat File Wizard‘ – the steps are very simple so I won’t repeat it out here —
Import Flat File to SQL Wizard 

I created a csv file(Test.csv) and txt file(TestSpace.txt) with some random data and used the wizard to upload the content into a SQL table – and it worked like a charm!

CSV File

SQl Table CSV File

Text File

SQl Table TXT File

One nice thing to note is that the Wizard is intelligent enough to identify patterns and perform predictive file splitting. After scanning through the data it also does a great job in predicting the data type of the column values.

Table Data type

However I would highly recommend you to review the table schema and modify accordingly before proceeding with the data import.

Modify Columns

 

Overall this is a pretty nice utility to have and can surely make your lives much easier while trying to import data into SQL Server tables. Please go ahead and install the 17.3 version of SSMS and empower yourselves with these additional features.

Here is the link to download SSMS 17.3 – 

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

2 thoughts on “Import Flat File Wizard in SSMS 17.3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s