Import/export data not available in SSMS21

[roberto21]

With the last version of SqlServer management studio (21) it appears that I have lost the possibility of launching the import/export data wizard. Right click on a database, click on tasks, and the two entries are greyed out and not useable (see attached image). I am sure that with SSMS 20.1 I did not have this problem. Is this a case where upgrading does no good, or am I missing something? I know that I can bypass the problem calling directly

"C:\Program Files\Microsoft SQL Server\160\DTS\Binn\DTSWizard.exe"

but this is a bypass, not an explanation or a solution.
In some posts on the web somebody says that the culprit is SSIS missing, and the SQL server Express does not include it in its installation; but if this is the case, why it worked before? And if this is the case, can you install SSIS alongside sqlexpress?

[June7]

Interesting, Import/Export is available with version 20 and I do not have SSIS.

I will have to install version 21 on another computer and see what happens.

My understanding is SSIS is not supported with Express, that it is not even an option to install alongside Express.

[roberto21]

I reinstalled SSMS 20 and I can confirm that the problem is NOT present there, everything works fine. So this upgrade did remove the import/export wizard. The question is: was it removed on purpose? The message you get with SSMS21 (21.3 should be the latest) is strange, to say the least...



If so, why?

[jojowhite]

are you using the Admin credential on opening the database?

[roberto21]

How do you do that? Even if you launch SSMS as administrator, the error is still present; and, again, it is NOT present in SSMS20, regardless of admin or not.

[NoellaG]

seems to be a known issue with some versions of SSMS: sql server - SQL Management Studio Task Import Data is greyed out - Stack Overflow
If you don't need the newer version, revert to the old one or use one of the work-arounds. Maybe in a next upgrade the issue will be fixed.

[roberto21]

Thank you. I had already seen that post, just hoped there would be an explanation. Probably Microsoft knows what is doing...
I switched to the old version for the moment. Thanks again.

[jojowhite]

just installed ssms21 today for test.
checked and nothing is Disabled.

i think you might not have included (checked) "Hybrid and Migration" (fig. 1). during installation
so the "feature" is not enabled.

figure 1:


figure 2:


figure 3:

[roberto21]

Thank you very much. I am not sure I've seen that screen (fig. 1) during installation, anyhow I modified the installation and now the feature is enabled. One remark, though: it is not enough to include "Hybrid and migration": I did that, and the feature was still disabled. I had to include the "business intelligence" as well to unblock the feature. Wonder what is the purpose of this complication. Thank you again

[madpiet]

(You have clearly never used PowerBI)

[roberto21]

Not sure what to make of your remark, but, as a matter of fact, I haven't...yet. I am just struggling with power query, and that's more than enough for the moment. If PowerBi (that, I admit, is tickling my curiosity) guarantees a mess like this one, I think I can wait a little longer.