question

NeerajaNair-4442 avatar image
0 Votes"
NeerajaNair-4442 asked Monalv-msft edited

integration service catalog node not visible ssms

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

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:
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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NeerajaNair-4442 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·