Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

SQL Server Management Studio 21 now supports SQL Server Integration Services (SSIS)

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Jun 12, 2025

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.

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

Updated Jun 24, 2025
Version 5.0

6 Comments

  • gert_hauan's avatar
    gert_hauan
    Copper Contributor

    We are using Visual Studio 2019 and SQL Server Integration Services Projects version 3.15, will that also be broken if we enable SSIS in SSMS 21?

  • This side-by-side issue with SQL Server Integration Services Projects 2022 with SSMS 21.2.5 and SSMS 21.3.6 is fixed in SQL Server Integration Services Projects 2022 V1.6 now.

    We are also in releasing a new version of SSMS, compatible with SQL Server Integration Services Projects 2022 V1.5 and below. We will continue to provide updates on the progress here.

    • Brashen's avatar
      Brashen
      Copper Contributor

      Morning. I have a clean install of SSMS21, VS2022 and SSIS 1.6.. VS2022 cannot open any ssis packages.....

      • Brashen's avatar
        Brashen
        Copper Contributor

        UPDATE:
        I can create NEW solutions but cannot open existing solutions. The solution files are different (well they have a different icon)

        Uninstalling SSMS 21, SSIS 1.6.2 and reinstalling SSIS.1.5 still leaves Visual Studio broken

  • SSMS 21.2.5 and later cannot function alongside SQL Server Integration Services Projects 2022.
    Installing SSMS 21.2.5 or any later version will cause SQL Server Integration Services Projects 2022 features to break.

    If SQL Server Integration Services Projects 2022 is broken after SSMS is installed, please uninstall SSMS 21.2.5 or any later version, and then run the VS SSIS extension repair.

    We are working on the fix, and will share the update as soon as possible.

  • Nekobul's avatar
    Nekobul
    Copper Contributor

    When do you plan to release the designer for VS ?