Link to home
Start Free TrialLog in
Avatar of larchevv
larchevv

asked on

Can I run the SSIS Service on a seperate server from the DB Server and still use the new SSISDB Catalog feature

For operation reason, I want to run my ssis service on a different server, one without a MSSQL DB.

However, I also want to use the SSISDB features from MSSQL 2012.

So far, I have not find a way to separate the service from its catalog.

Is it a requirement to have the service on the same server instance when using the SSISDB catalog feature? If not, what needs to be done to make it happen?

Many thanks
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

you still need to install ssis
yes, you can run SSIS Service on a seperate server from the DB Server and still use the new SSISDB Catalog feature
Avatar of larchevv
larchevv

ASKER

Thanks. Do you have an example on how to execute the package stored in a remote ssisdb catalog? I have not found a way to do it out of the box. Also, would it eliminate the possibility to run it from SSMS interface?
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial