Blog Post

SQL Server Integration Services (SSIS) Blog
7 MIN READ

Run Any SQL Anywhere in 3 Easy Steps with SSIS in Azure Data Factory

Sandy Winarko's avatar
Sandy Winarko
Icon for Microsoft rankMicrosoft
Jun 17, 2021
After releasing many features that unblock and accelerate the migration of SQL Server Integration Services (SSIS) packages into Azure Data Factory (ADF), see https://techcommunity.microsoft.com/t5/sq...
Updated Nov 14, 2021
Version 4.0
KaavTamil's avatar
KaavTamil
Copper Contributor
Mar 23, 2022

OLEDB connection works fine in SSIS-IR, setting Connectusingmanagedidentity to be true.
But my ADO.Net connection fails with same setting. It works well with SQL auth, but I have to make Managed identity work with ADO.NET connection.
Can you please help. Do you have a sample connection string for ADO.NET connection.