question

sakuraime avatar image
0 Votes"
sakuraime asked SaurabhSharma-msft edited

Azure SQL MI SSISDB

https://docs.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

azure-data-factoryazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft edited

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

okok. thanks .

so which means Azure sql MI also has the power to run the SSIS package ?? what's the actual difference with running at MI or From ADF SSIS IR

But if some package task need access on-prem data , like oracle , or some other task like executing some script . still can just run in SQL MI ?

0 Votes 0 ·

@sakuraime sorry, my bad, I have missed about provisioning Azure SSIS IR in ADF and yes, in order to run the packages through SQL MI you need to provision ADF SSIS IR. I have updated my previous answer with the correction. Also, SSIS IR can run processes/scripts on premises if it joins a VNet connected to the on-prem network or uses self-hosted IR as a proxy. So, SQL MI supports full backward compatibility, where all packages running on premises can also run on SSIS IR w/ no design change.

Please let me know if you have any questions.

Thanks
Saurabh

0 Votes 0 ·