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

ADO.NET connection manager should have ConnectusingManagedIdentity to be true.
Connection string should be just this -
Server=xxxx;Initial Catalog=sqldb;

Found it out. Thanks.