Question:
Many times we get a below question
Can I use new Microsoft.Data.SqlClient Provider with MFA / 2FA / Entra Id in SSIS Upsert Destination?
Answer:
No - Microsoft has released a new SQL Server driver with MFA support, which is not the same driver as the old ADO .net SQL connection it used to offer. This new driver is not backward compatible with older SSIS runtimes, so we cannot use it because many customers run older SQL versions such as SQL2012-2019.
Also, adding support for the new SQL Driver requires a lot of work on our end, including development and testing, so we will keep watching requests for this feature. If more people ask for it, we may consider it.