SSISDB package running and monitoring

Question

If the ssis package is deploy to SSISDB , do I still required the Integration service keep running in order to deploy / execute / monitor the package ?

I know executing the SSIS package in SSISDB doesn't required Integration service to keep running (use SQL agent to run the package).

Answer 1

Hi @sakuraime ,

What do you mean keep the Integration service running?

All Integration Services objects are stored and managed on an instance of SQL Server in a database referred to as the SSISDB catalog.

The catalog allows you to use folders to organize your projects and environments. Each instance of SQL Server can have one catalog. Each catalog can have zero or more folders. Each folder can have zero or more projects and zero or more environments.

deploy-integration-services-ssis-projects-and-packages

To run SSIS packages you may refer: run-integration-services-ssis-packages

Regards，

Zoe

---

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.
Hot issues October

Answer 2

so if using SSISDB as the package store , do I still need to install Integration Server on the same box of the sql server ?

Of course you still need SSIS to execute the package. But SSIS can be install on a different server (which requires an additional license).
SSISDB is just the storage for the package. You can store the package in file system, no big difference.