Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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