Installing integration Services with Web edition

SSIS and Import/Export
1

We have a hosted web server with sql server 2022 web edition which we pay the hosting company for.

We need to introduce some automation via ssis packages. Can we install integration services with web edition, or somehow execute / schedule the packages?

Thanks.

2

You should always check with Microsoft about licensing. This suggests SSIS is not allow with web edition.

Integration Services Features Supported by the Editions of SQL Server - SQL Server Integration Services (SSIS) | Microsoft Learn

3

Thanks - that is what I had feared!

I had read some suggestions of installing developer edition alongside Web edition to run the SSIS packages, but I assume that is not a recommended / accepted solution.

Has anyone else come up with any workarounds to this? Can We exceute packages via command line, or perhaps I need to look in to creating a Windows service for automation rather than SSIS?

4

The developer edition is not licensed for production environments.

Alternatives to SSIS really depend on what you want to do.

  1. Linked servers can work with low data volumes.
  2. Powershell, especially with dbatools, works well as long as the environment is not too complex.
  3. Python with Apache Airflow.
  4. ADF
  5. C# etc
  6. Various paid for tools.
    etc
5

Thanks again for that.

Most of the automation we wish to do is integrating with 3rd party API / Web Services - we need to send and receive data and files. Ordinarily I would just use SSIS packages to achieve this - had a quick look at dbatools functions that seems more to do with admin automation (as the name implies) - I am happy to build in C# (SSIS code is anyway) so would people recommend building some custom services, or are there tools out there that help with API integration?

What I like about SSIS packages is they are self contained (task/API specific) and can be easily debugged / scheduled etc - writing a web service to do it all seems like I would be creating a bit of a "black box" which would become unwieldy over time.

6

Powershell does have Invoke_RestMethod.

As you have the SSIS packages you might just want to upgrade your version of SQL Server to Standard or Enterprise.