Unable to extract OData to SSIS

Question

Hi

I am trying to extract Project online Odata to the SQL tables via SSIS Package. Authentication is successful but however getting below error when I run the package
SSDT : 2015 version
SQL Server: 2016

[OData Source [22]] Error: Cannot acquire a managed connection from the run-time connection manager

Please help me to get rid out

Answer 1

Hi @Santosh V ，

Please try below methods to see if it will be helpful.

1. Install Microsoft .NET 4.6 and above on your computer (https://technet.microsoft.com/en-us/library/security/2960358.aspx).
2. Enforce TLS 1.2 on your machine through registry settings. In an elevated command prompt run the following commands: reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64
   reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32

Reference: tls-issue-with-ssis-package-while-accessing-odata-source-like-dynamics-ax-online

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

Thanks a ton Zoe. I will check and update.

Thanks again

Answer 3

Thanks, Zoe

I am getting an incorrect password when I click on the test connection but nothing changed.
However, am able to login PWA with the same user name and password without any issues and also noticed MFA is disabled

Answer 4

Hi Zoe

I resolved myself for incorrect user name and password by making the required changes in Azure AD
Thanks again for your help on resolving first issue

Regards
Santosh