I am developing an ETL for a client.
The client asks me if the ETL packages can be executed without using the sql server database engine?
Thank you very much for your attention
I am developing an ETL for a client.
The client asks me if the ETL packages can be executed without using the sql server database engine?
Thank you very much for your attention
Starting from SQL Server 2012 onwards, SSIS is using Integration Services Catalog and SSISDB database. As such, you do need to install SQL Server engine (though it is strictly not needed) to leverage all the benefits of the current generation of SSIS.
Please see below.
Good link on the subject: Installing SQL Server Integration Services


Hello, thanks for answering.
Believe it or not, I did the installation with that guide that you shared 3 months ago, so I feel that when I installed the environment I did it correctly, I mean, I was on the right track to configure the environment.
Thanks for the link
I very much doubt that the db engine has to be installed in order to have SSIS running. SSISDB was introduced in 2012, but you don't have to use SSISDB.
I.e., I would like to see some documentation to support that the db engine is required before accepting this.
(The licensing topic is of course also important, but that is not what I'm addressing here.)
Hi @TiborKaraszi ,
You mean another alternative to run the package?
So far I understand that they can be run via Sql Agent and DTEXEC
What exactly do you mean by "can be executed without using the sql server database engine"?
SSIS packages do not directly depend on the SQL Server database engine. You can store the package on the file system (instead of SSISDB) and run it using DTEXEC. You can create SSIS packages which do not interact with SQL Server at all.
However, if you are asking can you execute SSIS packages without LICENSING SQL Server Database Engine, the answer is NO. If you use SSIS, you must have a license on the server. See the SQL Server Licensing guide.
Hello, thanks for answering.
I did the test of executing packages through DTEXEC and managed them through windows tasks, To have more control of the execution of the packages I used sql agent to save logs and detailed information.
But the client later He asks me if it is necessary to implement the solution not with the database engine.
Before responding to the client, I wanted to have the responses of the expert community to respond based on the client's requirements.
Thank you very much in advance for the answer.
Hi @OscarCastro-2723 ,
The client asks me if the ETL packages can be executed without using the sql server database engine?
We should install SQL Server firstly.
And then Install Integration Services (SSIS).
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello, thanks for answering.
Those were the steps I used to configure the environment thank you very much for the answer
Thank you for your answers.
I can execute an SSIS package using various methods, including DTEXEC,SQL Agent etc.
But In my case I have been able to execute the package from the SSISDB catalog, depending on what stage the project is in, I have been able to change the database connections (dev to qa) more easily with this tool, I understand that it is NO It is strictly necessary to install the SQL Server engine, but without this tool I am losing all benefits.
11 people are following this question.