Run SSIS package in SQL MI via Agent, not ADF IR

JoelP 296 Reputation points
2023-01-18T04:20:49.5433333+00:00

Do you still need ADF IR to run SSIS packages in SQL MI? or you can just schedule it via SQL Agent? Looking at below link, it does not look like you still need it. I know previously, you need ADF IR but just double checking since Azure keeps on adding features every now and then.

https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-managed-instance-agent

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,426 Reputation points MVP
    2023-01-18T04:41:43.7766667+00:00

    You can definitely run SSIS packages via by using Azure SQL Managed Instance Agent as explained on this article. You can run SSIS packages that are stored in SSISDB in a SQL Managed Instance, a file system like Azure Files, or an Azure-SSIS integration runtime package store by using Azure SQL Managed Instance Agent (that is equivalent to SQL Server Agent on SQL Server).

    0 comments No comments

0 additional answers

Sort by: Most helpful