Typically, a connection string to a database in SSIS which uses windows authentication would look like:
Data Source=0.0.0.0;Initial Catalog=databasename;Provider=SQLNCLI11.1;Integrated Security=SSPI;
my project uses Azure SQL Server to load data using SSIS and we use 'Active Directory - Universal with MFA Support' authentication mode, how do we give a connection string?
Project SSIS packages use OLE DB Connection managers which will use only Windows and SQL Server authentication.
