SSISDB package running and monitoring

sakuraime 2,286 Reputation points

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,082 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 22,211 Reputation points

    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.


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



    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 29,021 Reputation points

    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