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
470 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 38753238
you still need to install ssis
0
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Accepted Solution

by:
Eugene Z earned 500 total points
ID: 38753355
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

728 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