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'.
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
Asked:
3-
2
1 Solution
yes, you can run SSIS Service on a seperate server from the DB Server and still use the new SSISDB Catalog feature
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?
try DTEXEC
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
example
Executing SSIS Packages Using DTExec
http://www.databasejournal.com/features/mssql/article.php/3897236/Executing-SSIS-Packages-Using-DTExec.htm
and even without SSIS install (save sql server license)
via
sysinternals PSexec (just need wind admin rights there)
http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx
see example @
http://www.lifeasbob.com/2008/11/21/RemoteExecutionOfAnSSISPackage.aspx
---
also there are another ways :
http://sqlblog.com/blogs/alberto_ferrari/archive/2009/12/02/remote-execution-of-ssis-packages.aspx
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
example
Executing SSIS Packages Using DTExec
http://www.databasejournal.com/features/mssql/article.php/3897236/Executing-SSIS-Packages-Using-DTExec.htm
and even without SSIS install (save sql server license)
via
sysinternals PSexec (just need wind admin rights there)
http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx
see example @
http://www.lifeasbob.com/2008/11/21/RemoteExecutionOfAnSSISPackage.aspx
---
also there are another ways :
http://sqlblog.com/blogs/alberto_ferrari/archive/2009/12/02/remote-execution-of-ssis-packages.aspx
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
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 Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now