SQL Management Studio Task Import Data is greyed out

Question

Database: SQL2017 Express Management Studio 18 System: x64 I have sysdmin / db owner etc & database is accessible/updateable.

"This feature is not currently available in this version or the database is not available"

I solved this by using (Menu start-> type "Import" which runs DTSWizard.exe), but it still doesnt work from SSMS.

Answer 1

We can open the "SQL Server Import and Export Wizard" without the help of SQL Management Studio.

The path is something like this (depending on your version):

"C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTSWizard.exe"

Answer 2

What version of SSMS do you have installed? I had the same problem with v18 preview 4 and rolled back to 17.9 which resolved the problem for me.

Answer 3

Notice that you can also import data from files (for example CSV files) using the option you got there of "import flat file". A wizard will open and allow you to choose the file you want to import