Solved

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

Posted on 2013-01-07
5
453 Views
Last Modified: 2016-02-10
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
Comment
Question by:larchevv
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38753238
you still need to install ssis
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38753241
yes, you can run SSIS Service on a seperate server from the DB Server and still use the new SSISDB Catalog feature
0
 

Author Comment

by:larchevv
ID: 38753279
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
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 38753355
0
 

Author Comment

by:larchevv
ID: 38759419
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question