2
votes

In SQL Server there is a separate Server we install for SSIS but when we deploy a project it goes to SQL Server Database engine (Integration Services Catalogs, SSISDB).

Object Explorer connected to both SQL Server & Integration Services

What is the use of this Integration Services here? I'm new to this and couldn't find any article talking about this Integration Services login.

1
You don't need it. It exists for older package types. In fact, the latest versions of SSMS can't even connect to itPanagiotis Kanavos

1 Answers

-1
votes

In SSIS, when you choose package deployment model and create a deployment utility ie Deployment manifest, at that time we have option of deploy it on integration services.

In SQL 2012+ By default we use project deployment which creates our .dtsx in SSISDB folder under Integration Service Catalog.

As said in comments, it is just for compatibility purpose now.

Here is a short demonstration of how to use it :

image1

then click next :

image2

Now you will be able to see the package inside MSDB folder. From here you can run the package as well as maintain it.