Archive

Posts Tagged ‘Import Flat File Wizard’

Import Flat File Wizard–New Feature in SQL Server Management Studio v 17.3

October 10, 2017 Leave a comment

SQL Server Management Studio v 17.3 is released and available for download now, it packs lot of new features and updates

One of the most interesting features is “Import Flat File” Feature which can help novice to experienced users to load Flat file to SQL Server

capture20171010153301560

“Import Flat File” option is available at Database level under Tasks Context menu

capture20171010151258718

In this article, I am using FDA’ Orange Book Data product files for loading, as you can see this file is separated by ~

FDA Orange Book Data Files

capture20171010151446560

Please click “Next” to start the Import Flat File  process

capture20171010151620937

Please select the Input file, The tool is smart and it uses the File name as Target table name

capture20171010151714495

But if we prefer, we can change the Target table according to our needs or naming convention

capture20171010151751094

Click “Next” to proceed to “Preview Data” screen, In “Preview Data” screen we can see the sample records

capture20171010151752654

After previewing the data, Please click “Next” to proceed to “Modify Columns” screen, based on sampled rows, it automatically suggests the data types, but we can change the Data Type based on our input source specification, in this case, I have changed the “Applicant_Full_Name” to NVARCHAR(500) from NVARCHAR(100) and also we can specify Primary Key, which I have selected “Appl_No” and “Product_No” as Combined Primary Key

capture20171010152124723

After making required changes to Column definition, Please click to proceed, depending on the size of the data, the Import operation will run and complete

capture20171010152556076

You can click on the “Success” hyperlink in Result to view the Completed message, once reviewed, Please click “Close” to continue

capture20171010152600380

Now let us review the data imported, We can see the new table is created

capture20171010152614195

We are running a simple Select Query to see all records loaded, We can see 2499 rows are loaded

capture20171010152715115

This tools is really simple and easy to use, I believe you will find this article helpful

Advertisements
%d bloggers like this: