I installed SSMS 21.4.8 on SQL Server 2022, but the Import/Export option is grayed out and cannot be clicked

Question

I installed SSMS 21.4.8 on SQL Server 2022, but the Import/Export option is grayed out and cannot be clicked

Terashi, Masataka/寺師正貴 30

I installed SSMS 21.4.8 on a computer with SQL Server 2022, and I want to export a database, but the option is grayed out and cannot be clicked. I’ve tried reinstalling SSMS and updating the OLE and ODBC drivers to the latest versions, but it still doesn’t work. How can I investigate the cause, and what should I do to enable the export function?

Viorel 126.9K Reputation points

2025-09-11T10:39:45.1466667+00:00

Until the problem is resolved, see if the program can be started directly. The path may be C:\Program Files\Microsoft SQL Server\160\DTS\Binn\DTSWizard.exe.
Terashi, Masataka/寺師正貴 30 Reputation points

2025-09-11T11:02:03.6066667+00:00

Thanks for your reply. I do have up to C:\Program Files\Microsoft SQL Server\160, but there was no DTS folder. I also searched for 'DTS' within C:\Program Files\Microsoft SQL Server\160\ but found no matches.

Answer accepted by question author

0 additional answers

Your answer

Viorel 126.9K Reputation points

2025-09-11T10:39:45.1466667+00:00

Until the problem is resolved, see if the program can be started directly. The path may be C:\Program Files\Microsoft SQL Server\160\DTS\Binn\DTSWizard.exe.
Terashi, Masataka/寺師正貴 30 Reputation points

2025-09-11T11:02:03.6066667+00:00

Thanks for your reply. I do have up to C:\Program Files\Microsoft SQL Server\160, but there was no DTS folder. I also searched for 'DTS' within C:\Program Files\Microsoft SQL Server\160\ but found no matches.

Answer 1

Viorel 126.9K

According to some articles (https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-release-of-sql-server-management-studio-ssms-21-2-5/4422488), to include the Wizard, try to modify the installation of Management Studio.

Close Management Studio, start the Installer (https://learn.microsoft.com/en-us/ssms/install/modify) go to Modify, to Individual components, and select the “SQL Server Integration Services (SSIS) (Preview)”. Finish the installation.

Terashi, Masataka/寺師正貴 30 Reputation points

2025-09-15T00:25:14.2833333+00:00

Thank you for the helpful information. I’d love to try it right away, but I’m currently in an offline environment and won’t have time this week. I’ll get back to you with the results after I’ve tried it.
Terashi, Masataka/寺師正貴 30 Reputation points

2025-09-18T05:24:00.1333333+00:00
Thank you very much. Based on the information you provided, I was able to successfully enable import/export functionality by installing SSIS additionally. Since the environment I’m building is offline, that may be the reason, but I’d like to note a few points that required special attention:

The offline installer must be created with --all to include all components.

SSIS was not usable when added after updating an older version. After uninstalling, installing SSMS and SSIS simultaneously made it usable.
bsiele 0 Reputation points

2025-11-06T09:44:00.15+00:00

This works like a charm. Thank you. I actually installed the Business Intelligence component.
Bukola Zinpe 0 Reputation points

2026-01-13T10:30:24.6833333+00:00

Thanks so much, i had the same issue and this solves it.

Share via

I installed SSMS 21.4.8 on SQL Server 2022, but the Import/Export option is grayed out and cannot be clicked

0 additional answers

Your answer