i am using sql server 2008 r2 and intergration severces is enabled but the node for integration services not showing in ssms
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
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Hi @NeerajaNair-4442 ,
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:
2.Integration Services (SSIS) Server and Catalog
3.Introduction to the SSIS Catalog database (SSISDB)
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.
5 people are following this question.