Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

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
0
larchevv
Asked:
larchevv
  • 3
  • 2
1 Solution
 
Eugene ZCommented:
you still need to install ssis
0
 
Eugene ZCommented:
yes, you can run SSIS Service on a seperate server from the DB Server and still use the new SSISDB Catalog feature
0
 
larchevvAuthor Commented:
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?
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now