Azure SQL MI - Execute SSIS Package without Azure ADF

Question

If we have a Azure Managed Instance why do we need Azure ADF as a pre-requite to run the SSIS Package.
Can you please help clarity the below line marked under pre-requisite.

"You also need to provision an Azure-SSIS integration runtime in Azure Data Factory. It uses a SQL Managed Instance as an endpoint server.
"
https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-managed-instance-agent

Secondly,
Also how can I provision a SSISDB in Azure without using Azure ADF. Is there a way or its the only way to provision a SSISDB in Azure?

Answer 1

Hi, anonymous user Thanks for posting your query in the Microsoft forum,

SQL MI doesn’t have an SSIS engine that can run SSIS packages, but it can host MSDB/SSISDB to store SSIS packages and has SQL MI Agent that can orchestrate/schedule SSIS package executions on SSIS IR in ADF

If you want to provision SSISDB in SQL DB/MI (PaaS), you need SSIS IR in ADF, which is a managed SSIS platform (also PaaS). Alternatively, you can use SQL VM (IaaS) to host SSISDB and run SSIS packages, but you manage SSIS platform yourself.

Please let me know if you need any other information.
Regards
Geetha

Answer 2

Hi,

Is this still the case for 2023?

Thank you in advance,

Alexandros