Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer

Question

Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer

Sabyasachi Paul 0

Hello,

I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro.

I installed:

Database Engine Services (Default instance: MSSQLSERVER)

Integration Services (added later via “Add features to existing instance”)

SQL Server Management Studio 22 (latest version)

My Windows account has sysadmin privileges. I verified this by running:

SELECT IS_SRVROLEMEMBER('sysadmin');

The result returned 1.

However, when I right-click my user-created database (not system databases) → Tasks, the “Import Data…” and “Export Data…” options are greyed out.

Additional details:

I am connected using Windows Authentication.

I have tried running SSMS as Administrator.

Integration Services is installed and visible in setup.

The folder C:\Program Files\Microsoft SQL Server\170\DTS\Binn\ exists.

The Import/Export wizard does not appear to launch from the context menu.

Could you please clarify:

Is this expected behavior in SSMS 22 with SQL Server 2025?

Is there an additional client component required for the Import/Export Wizard?

Is this a known UI limitation in recent SSMS versions?

Thank you for your assistance.

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer recommended by moderator

AI answer

The issue you are experiencing with the "Import Data..." and "Export Data..." options being greyed out in SQL Server Management Studio (SSMS) 22 while using SQL Server 2025 could be related to several factors:

User Permissions: Although you have verified that your account has sysadmin privileges, ensure that you are connected to the correct database and that there are no additional permissions or roles that might be affecting your access.
Integration Services Installation: You mentioned that Integration Services is installed, which is necessary for the Import/Export Wizard to function. However, ensure that it is properly configured and running. You might want to check the SQL Server Configuration Manager to confirm that the Integration Services service is running.
SSMS Version Compatibility: There might be compatibility issues or limitations with the current version of SSMS you are using. As of SQL Server Management Studio 21 and SQL Server 2025, the Import and Export Wizard only supports a 64-bit environment. If there are any older components or configurations, they may not be compatible.
Client Components: Ensure that all necessary client components are installed. Sometimes, additional components may be required for specific functionalities within SSMS.
Known Limitations: There might be known UI limitations or bugs in the recent versions of SSMS that could affect the visibility of these options. Checking for updates or patches for SSMS could help resolve such issues.

If the problem persists, consider checking the SQL Server logs for any errors or warnings that might provide more insight into the issue.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

2 additional answers

Answer 1

Erland Sommarskog 138.4K MVP Volunteer Moderator

Launch the Visual Studio installer (which you find in the Visual Studio 2026 program group), and select Modify for SSMS and add the Business Intelligence workload to get SSIS support which you need for the Import/Export stuff.

Anonymous

2026-03-06T01:42:11.3633333+00:00

Hi @Sabyasachi Paul ,

As mentioned by the @Erland Sommarskog the Import/Export Wizard requires SSIS components. Please open the Visual Studio Installer, select Modify, and install the Business Intelligence workload to add SSIS support.

If the issue persists, please share the results after installing the BI workload so the community can assist further.

Thanks,
Akhil.
Anonymous

2026-03-11T08:33:36.29+00:00

Hi @Sabyasachi Paul ,

As mentioned earlier by @Erland the Import/Export Wizard requires SSIS components. Installing the Business Intelligence workload through the Visual Studio Installer (Modify → select BI workload) should add the required SSIS support.

If the issue still persists, please feel free to reopen the thread and share the results after installing the BI workload so the community can assist further.

Thank you,
Akhil.

Answer 2

Viplove Desai 0

Morning,

Does anyone have the same problem? Our SSMS was installed today (Version SQL Server Management Studio22.11.0+169.12306.390) and even after installing the BI Workload, as Paul suggested, the Import/Export is greyed out. Any help will be appreciated.

Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator

2026-10-20T13:37:39.8866667+00:00

Please ask a new Question instead of piggybacking on old threads. I would run the Visual Studio installer and double-check that the BI workload is installed.