question

sakuraime avatar image
0 Votes"
sakuraime asked OlafHelper-2800 answered

SSISDB package running and monitoring

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

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT commented

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

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

0 Votes 0 ·

The Integration Services server is an instance of the SQL Server Database Engine that hosts the SSISDB database. If you want to use SSISDB, you may need to install Integration Server.
install-integration-services
integration-services-ssis-server-and-catalog


0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



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.