SSIS packages running on Azure-SSIS Integration Runtime can use Managed Identities to connect to ADLS Gen2, eliminating the need to hardcode credentials.
microsoft SQL Server 2019 Integration Services Feature Pack for Azure ssis440 2021
Provides native connectivity, utilizing OAuth authentication (Azure Active Directory/Managed Identities) for improved security. SSIS packages running on Azure-SSIS Integration Runtime can