AzureFeeds

With the release of SQL Server Management Studio (SSMS) 21.2.5, SQL Server Integration Services (SSIS) is now available in Preview. You can install it 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 21, 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.

Known Issues

1. SQL Server Import and Export Wizard, when selecting a Data source other than Microsoft OLEDB Provider for SQL Server, please apply the following workaround. Add dependentAssembly inside section of “C:Program FilesMicrosoft SQL Server Management Studio 21ReleaseCommon7IDECommonExtensionsMicrosoftSSIS170Binndefault.applocal.config”:

       This issue will be fixed in the next version.

2. Execute Package Utility (dtexecui) is not supported yet. This will be supported in the next version.


3. Legacy Integration Services Service is not supported yet.

Learn More 

Announcing the release of SQL Server Management Studio (SSMS) 21.2.5 | Microsoft Community Hub

Release Notes for SQL Server Management Studio (SSMS) | Microsoft Learn

Known Issues in SQL Server Management Studio | Microsoft Learn