sql-serversql-server-2008ssissql-server-2008-r2

Missing Integration Services Catalog in Management Studio


I have SQL Server 2008 R2 SP3 standard edition installed. I access remote to the server where SQL Server is installed. The option of the integration services catalog is missing under the database connection.

I did check the followings

Any ideas? Help!


Solution

  • That's because you're using SSMS 2008. The Integration Services Catalog was introduced with SQL Server 2012. The older client doesn't know that's a "thing."

    I prefer to manage servers with the latest and greatest version of SSMS which is now a free download.

    Microsoft® SQL Server® 2014

    Choose "MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe"

    For clarification

    Integration Services Catalog

    Integration Services Catalog

    Integration Services Object Explorer

    Integration Services Object Explorer