integration service catalog node not visible ssms

Neeraja Nair 1 Reputation point
2021-03-11T05:11:33.69+00:00

i am using sql server 2008 r2 and intergration severces is enabled but the node for integration services not showing in ssms

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,576 Reputation points
    2021-03-11T05:38:46.97+00:00

    SSIS catalog won't be present in SQL 2008 R2 version. As I know, it was launched starting from version SQL 2012 and onwards versions

    https://learn.microsoft.com/en-us/sql/integration-services/service/integration-services-service-ssis-service?view=sql-server-ver15

    https://www.mssqltips.com/sqlservertip/4097/understanding-the-sql-server-integration-services-catalog-and-creating-the-ssisdb-catalog/

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2021-03-11T07:00:50.577+00:00

    Hi @Neeraja Nair ,

    After you design and test packages in SQL Server Data Tools, you can deploy the projects that contain the packages to an Integration Services server. Before you can deploy the projects to the Integration Services server, the server must contain the SSISDB catalog. The installation program for SQL Server 2012 (11.x) does not automatically create the catalog; you need to manually create the catalog by using the following instructions.

    *Using this catalog, developers and database administrators can easily deploy and manage their integration services projects after deployment. The * SSIS Catalog database was introduced in SQL Server 2012.

    Please download new version SQL Server.

    Hope the following links will be helpful:
    1.SSIS Catalog
    2.Integration Services (SSIS) Server and Catalog
    3.Introduction to the SSIS Catalog database (SSISDB)

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.