Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL SERVER | SSMS 17.3 New Feature – Import Flat File Wizard

In this post we shall understand a new feature added in SSMS by Microsoft. Microsoft has added a new Import Flat File wizard SSMS version 17.3. This new Import Flat File wizard will to make a flat file import very easy.

Import Flat File wizard
In SQL Server Management Studio 17.3 Microsoft gave users new functionality: Import Flat File wizard.

Step1 : Go to Object Explorer -> Right click on your database -> Tasks -> Import Flat file

Step2 : Specify input file
The developer has to use this page to provide the source file and destination table name. You can select *.txt and *.csv files. The new table should be not be present in the database. If the table is already present in the database the Import file wizard will not continue.

Step3 : Preview Data
Here we can preview our flat file data. Note it shows only the first 50 rows from the data.

Step4 : Modify Columns
On this page you can verify or change column names, data types and other attributes.

Step5 : Summary
This page of the wizard provides us the summary of the import process.

Step6 : Results
The final page gives information like whether import was successful or not.

Notes –

With this we didn’t have to describe file format. It is because of an intelligent framework known as Program Synthesis using Examples (PROSE).

Data Verification

--

SELECT * FROM FlatFile

--OUTPUT

Id          Name                                               Sal
----------- -------------------------------------------------- -----------
1            Pawan                                             1500
2            Avtaar                                            2000

(2 rows affected)


--

Reference –

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard

Other new features in SQL SERVER 2017

# New Feature URL
1 STRING_AGG() https://msbiskills.com/2018/01/10/new-t-sql-features-in-sql-server-2017-iii-string_agg/
2 TRIM() https://msbiskills.com/2018/01/10/new-t-sql-features-in-sql-server-2017-ii-trim-function-remove-leading-and-trailing-spaces-from-a-string/
3 DBCC CLONEDATABASE https://msbiskills.com/2018/01/08/new-t-sql-features-in-sql-server-2016-iv-dbcc-clonedatabase/
4 SQL Operations Studio https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
5 Multiple OS for SQL Server 2017 https://msbiskills.com/2018/01/20/new-in-sql-server-2017-sql-server-available-in-multiple-operating-systems/
6 CONCAT_WS https://msbiskills.com/2018/01/20/new-t-sql-features-in-sql-server-2017-v-concat_ws/
7 TRANSLATE function https://msbiskills.com/2018/01/20/new-t-sql-features-in-sql-server-2017-iv-translate/
8 Resumable online index rebuild operation https://msbiskills.com/2018/01/21/new-t-sql-features-in-sql-server-2017-vii-resumable-online-index-rebuild/

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com