Hi Guys, Today when I was just doing some R&D with SQL server 2016 CTP2, got a new feature in “SQL Server Import and Export Wizard”. I was just importing a CSV file and got a new feature in advance tab as New, Delete and Suggest Types..
The detail step by step screen snaps as below,
Step 1 – Start “SQL Server Import and Export Wizard”, it will shows welcome screen as
Click on Next
Step 2 – Select Data source as ” Flat File Source” , then Browse CSV file.
Step 3 – Click on Columns, it will display all columns details
Step 4 – Click on ADVANCEED, it will show advance details, there will be 3 New botton as below, marked in RED.
Step 5 – When click on NEW button, it will be add new column options at current selected column as
Now, rest steps are as previous.
.
Please share your finding/observations.
WikiDBA 