SQL Server Management Studio 22 Preview now supports SQL Server Integration Services (SSIS)

Microsoft

Oct 16, 2025

SQL Server Integration Services (SSIS) support in SQL Server Management Studio 22 Preview

Alongside the Release of SQL Server Management Studio 22 Preview 3, SQL Server Integration Services (SSIS) is now available for installation. Integration Services 2025 Preview is better supported release and Legacy Integration Services Service is supported by SSMS 22 release.

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 Issues

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.
Using the Execute Package Utility (dtexecui) to run Integration Packages with Script Task fails. Manually download and install Microsoft Visual Studio Tools for Applications 2022 first before running package execution to work around this issue.
Maintenance Tasks (Including Back Up Database Task, Check Database Integrity Task, Execute SQL Server Agent Job Task, Execute T-SQL Statement Task, History Cleanup Task, and Maintenance Cleanup Task) are not supported by Execute Package Utility (dtexecui). This issue will be fixed in the coming release.
SSIS Integration Runtime creation wizard is not supported. As the workaround, use Azure Data Factory portal to Create an Azure-SSIS integration runtime.