SQL Server Management Studio 22 generally availability has been released. SSMS 22 GA version is recommended to use with Integration Services, as Integration Services 2025 is better supported and known issues from previous versions have been resolved.
You can install SQL Server Integration Services by selecting Modify in the Visual Studio Installer, adding the Business Intelligence workload, or from the Individual components tab if you only want SSIS. If you are updating a previously installed version of SSMS 22, after the update has finished installing you will need to go back to the Visual Studio Installer and add the SSIS component from the Modify workflow. For further details, refer to Install SQL Server Management Studio.
Known limitation
- Starting with SQL Server Management Studio 21 and SQL Server 2025, the Import and Export Wizard only support a 64-bit environment. For further details, refer to Import from Excel or Export to Excel with SSIS.
- SSIS Integration Runtime creation wizard is not supported. As the workaround, use Azure Data Factory portal to Create an Azure-SSIS integration runtime.
Learn More
SQL Server Management Studio (SSMS) 22 is now Generally Available (GA) | Microsoft Community Hub
Release Notes for SQL Server Management Studio (SSMS) | Microsoft Learn
Known Issues in SQL Server Management Studio | Microsoft Learn
Microsoft