0

We are planning on installing SSIS 2016 on a new dedicated ETL server.

The packages will be called from SQL Server Agent (on a separate server), or from an application (again on a separate server).

From reading the Microsoft docs, it seems that we need to install Database Engine along with Integration Services on the dedicated SSIS server. Is Database Engine required on the SSIS server for our needs?

I'm confused by this: "If the ETL server does not have an instance of the Database Engine, you have to schedule or run packages from a server that does have an instance of the Database Engine". Does this also mean that the SSIS server is then redundant if run from a server that does have DB Engine?

  • 1
    We have a dedicated SSIS server as well, but it has a database engine on the server, we just don't use it for anything except the SSIS catalog and scheduling tasks. – Jonathan Fite Nov 9 '18 at 13:47
0

You can install SSIS on a dedicated server. It will provide the capability of designing, executing and storing the packages. Packages would be accessible from agent service installed on other server as in your case. I see no issue in this design as per your requirement. However this design will not use resources on dedicated SSIS server. All execution load will be on calling server with database engine.

  • But to store the packages I need Database Engine installed? So Integration Services alone is not enough? – Kevin Nov 9 '18 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.