0

Our Organization is planning to cut costs on SQL Sever licenses. We use SSIS for our ETLs. Is it possible to install only SSIS with a MySQL server and without SQL Server?

Sri Paruchuri
  • 11

2 Answers2

1

No, you can't run SSIS without also running the SQL Server engine, which means paying a license.

The reason for this is quite simple, SSIS is a SQL Server component/feature. It is integrated in the SQL Server Engine.
And you will at a minimum require a standard SQL Server edition to use the SSIS runtime.

Reaces
  • 5,597
  • 4
  • 38
  • 46
0

I think no. There is used MS SQL Server to store SSISDB, so you can't install SSIS without SQL Server. You can split SSIS out from SQL server and use one server for SSIS and the other server for databases. If you do this, you will need to license both servers which will drive up costs.

Alexander Tolkachev
  • 4,608
  • 3
  • 14
  • 23