3

Using Visual Studio 2017 (SSDT), I'm attempting to create a SSIS package that will send data to an Azure DB that uses the authentication method "Active Directory - Password".

What type of a connection can be used in SSIS to connect to an Azure DB that uses that type of authentication? The only authentication options are "Windows Authentication" and "SQL Server Authentication" when using the "Native OLE DB\SQL Server Native Client 11.0" provider. Is there a different provider that works with Azure DBs that use the authentication method "Active Directory - Password"?

enter image description here

Improve this question
1
  • 2
    OLE DB doesn't support it. ADO.Net does. You'll need to use an ADO.Net connection instead Commented Dec 22, 2018 at 2:22

1 Answer 1

Reset to default
2

OLE DB doesn't support the "Active Directory - Password Authentication", but ADO.NET does. enter image description here

Connecting to Azure SQL Server from SSIS using ‘OLEDB Connection manager’ is not a straight forward way, if you are to connect using your ‘Azure Account’ credentials. The only way to connect using ‘Azure Account’ is by using ‘ADO.NET connection’ manager.

If you want to connect to Azure DB by using "Native OLE DB\SQL Server Native Client 11.0" provider, here is the tutorial maybe can help you:Connecting to Azure SQL Server using OLEDB Connection from SSIS

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.