ssisssmsssms-21

Upgraded SSMS from SSMS 20 to SSMS 21 - now the "Integration Services Catalogs" is not visible anymore

After upgrading from SQL Server Management Studio (SSMS) v20 to SSMS v21, the "Integration Services Catalogs" is no longer visible.

Steps to reproduce

  1. Upgrade SSMS from version 20 to version 21
  2. Open SSMS 21
  3. Navigate to the "Object Explorer" pane
  4. Look for the "Integration Services Catalogs" node

Expected result

The "Integration Services Catalogs" should be visible and accessible in the "Object Explorer" pane, as it was in SSMS 20.

Actual result

The "Integration Services Catalogs" is not visible in the "Object Explorer" pane in SSMS 21.

Additional Information:

SSMS 20

SSMS 21

Solution

  • SSIS, and maintenance plans, are not yet supported in SSMS 21. Despite it going to full release, they held back support for a later date.

    From the release announcement:

    SSIS and Maintenance Plans

    We made the difficult decision to hold back SQL Server Integration Services (SSIS) support for this release. This includes the import/export functionality and Maintenance Plans. In the spirit of full transparency, during the final weeks of testing, we recognized that SSIS needed additional time to ensure the quality and stability our users expect, so we made the decision to temporarily hold it back while we continue to enhance the experience. Our primary focus for SSMS 21 was to move to Visual Studio 2022, provide initial support for SQL Server 2025 Preview, and support the Copilot in SSMS Preview. Our team is actively working to bring these features back in an upcoming release. For now, if you rely on SSIS we recommend using SSMS 20, which you can install side-by-side with SSMS 21 GA.