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

asked 2021-03-02T17:28:21.77+00:00
Oscar Castro 21 Reputation points

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,476 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,840 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-03-02T18:02:59.233+00:00
    Yitzhak Khabinsky 19,846 Reputation points

    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


3 additional answers

Sort by: Most helpful
  1. answered 2021-03-02T18:46:03.813+00:00
    Tom Phillips 17,511 Reputation points

    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.


  2. answered 2021-03-03T06:37:40.38+00:00
    Monalv-MSFT 5,686 Reputation points

    Hi @Oscar Castro ,

    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.


  3. answered 2021-03-03T18:26:18.4+00:00
    Oscar Castro 21 Reputation points

    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.

    No comments