Run SSIS Packages using Azure Elastic Job Agent

Vincent Molloy 0 Reputation points
2024-03-28T13:38:04.02+00:00

Hi,

I would like to migrate some on-prem SSIS packages (and T-SQL based jobs) that are called from SQL Agent.

I understand that the packages can be executed in Azure Data Factory using the SSIS runtime.

However, I am wondering whether this is needed if I am using Elastic Job Agent.

The article below suggests that you can create the SSISDB in Azure SQL and use T-SQL to register packages, targets and scheduling information.

https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-schedule-packages?view=azuresqldb-current#elastic

What I don't understand is "how" the SSIS packages can be executed - where does the SSIS runtime component fit in with this approach. Does it still require ADF and SSIS runtime setup?

I understand that elastic job agent is in preview and there may be components that exist behind the scenes but have not yet been surfaced to the portal.

Thanks in advance for any advice

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
930 questions
{count} votes