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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
For other to use. EugeneZ's answer led me to a couple of other useful links:
http://blogs.msdn.com/b/mattm/archive/2011/07/24/using-dtexec-with-packages-on-the-is-server.aspx
http://www.biadmin.com/2012/08/ssis-2012-gotcha-dtexecexe-and.html
http://www.mattmasson.com/index.php/2012/02/exit-codes-dtexec-and-ssis-catalog/
http://msdn.microsoft.com/en-us/library/hh231187.aspx
http://blogs.msdn.com/b/mattm/archive/2011/07/24/using-dtexec-with-packages-on-the-is-server.aspx
http://www.biadmin.com/2012/08/ssis-2012-gotcha-dtexecexe-and.html
http://www.mattmasson.com/index.php/2012/02/exit-codes-dtexec-and-ssis-catalog/
http://msdn.microsoft.com/en-us/library/hh231187.aspx