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.
Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 57.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sabyasachi Paul
0
Reputation points
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.
SQL Server | Other
2 answers
Sort by: Most helpful
-
Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator2026-02-22T20:35:10.22+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator2026-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. -
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
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.
Sign in to comment -
-
Q&A Assist2026-02-22T20:30:18.94+00:00 AI generated content. This question contains an answer created with AI from Q&A Assist. Learn moreThe 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: