Unable to extract OData to SSIS

Santosh V 116 Reputation points


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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,386 Reputation points

    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



    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

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Santosh V 116 Reputation points

    Thanks a ton Zoe. I will check and update.

    Thanks again

  2. Santosh V 116 Reputation points

    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


  3. Santosh V 116 Reputation points

    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


    0 comments No comments