CODEWITHSUNDEEP
azuressis
wedwo
wedwo

Reputation: 398

Which Azure SQL products allow me to deploy SSIS packages?

We are looking at migrating our SQL Server, SSIS packages from an on-premise environment to Azure. Which Azure SQL Server products provide SSIS functionality? I understand the data lake environment does, but can I, for example, simply deploy an Azure general purpose single instance database and get SSIS? Just to be clear, I want to deploy 3 SQL databases and use SSIS to ETL data between them without having a VM or running SSIS on-premise. Thanks in advance!

Upvotes: 1

Views: 728

Answers (2)

wedwo
wedwo

Reputation: 398

OK, I think I have found a more comprehensive answer here: https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15

Azure Data Factory hosts the runtime engine for SSIS packages on Azure. The runtime engine is called the Azure-SSIS Integration Runtime (Azure-SSIS IR). For more info, see Azure-SSIS Integration Runtime.

enter image description here

Effectively you were right, Thiago - it's both Azure data factory for SSIS Integration Runtime and a SQL Server managed instance!

Upvotes: 0

Thiago Custodio
Thiago Custodio

Reputation: 18387

You should use SQL Managed Instances. Here are useful links

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance

https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance

PS: study the alternative I've left as comment too (for cost saving reasons)

Upvotes: 1

Related Questions