question

OscarCastro-2723 avatar image
0 Votes"
OscarCastro-2723 asked Monalv-msft edited

Can I install SSIS whitout database engine in SQL Server 2019 on Windows?

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

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered OscarCastro-2723 commented

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

73438-ssisdb-catalog.png

73874-sql-server-integration-services-ssis-historical-pr.jpg



· 9
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.)

0 Votes 0 ·

Hi @TiborKaraszi ,

You mean another alternative to run the package?

So far I understand that they can be run via Sql Agent and DTEXEC

0 Votes 0 ·
Show more comments
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered OscarCastro-2723 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello, thanks for answering.

Those were the steps I used to configure the environment thank you very much for the answer

0 Votes 0 ·
OscarCastro-2723 avatar image
0 Votes"
OscarCastro-2723 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.