Azure SQL MI SSISDB

Question

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

the above link show how to migrate the ssisdb to Azure sql MI, and suppose these package are in Azure sql MI already .

So in order to trigger the package in Azure sql MI , we can use Azure SQL MI agent , storeprocedure ....

Question is , do I still need SSIS Runtime from Azure data factory

Answer 1

Hi @sakuraime ,

Thanks for using Microsoft Q&A !!
Yes, if you want to execute these packages from SQL MI Agent you need to provision an Azure SSIS integration runtime with SQL Managed Instance as an endpoint server. SQL MI can only host SSISDB for SSIS IR, where SSIS IR fetches packages from SSISDB, runs them on its nodes, and writes logs back into SSISDB. All package executions on SSIS IR can be orchestrated by SQL MI Agent, regardless of their data sources/destinations.

Please let me know if you have any other questions.

Thanks
Saurabh
---------
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.