SSISDB package running and monitoring

sakuraime 2,316 Reputation points
2021-09-14T05:02:25.233+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 32,081 Reputation points
    2021-09-14T05:54:05.76+00:00

    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


  2. Olaf Helper 40,156 Reputation points
    2021-09-16T11:53:20.18+00:00

    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.

    0 comments No comments