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
-
SSMS 21.2.5 cannot function alongside SQL Server Integration Services Projects 2022 version 1.5 and below. Installing SSMS 21.2.5 or SSMS 21.3.6 will cause SQL Server Integration Services Projects 2022 version 1.5 and below features to break.
If SQL Server Integration Services Projects 2022 is broken after SSMS is installed, please upgrade SQL Server Integration Services Projects 2022 to Version 1.6.2.
- 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 <assemblyBinding> section of "C:\Program Files\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\CommonExtensions\Microsoft\SSIS\170\Binn\default.applocal.config":
<dependentAssembly>
<assemblyIdentity name="Microsoft.SqlServer.BatchParser" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="17.0.0.0" newVersion="17.100.0.0"/>
<codeBase version="17.100.0.0" href="{0}\Microsoft.SqlServer.BatchParser.dll"/>
</dependentAssembly>
This issue will be fixed in the next version.
- Execute Package Utility (dtexecui) is not supported yet. This will be supported in the next version.
- 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