Unable to extract OData to SSIS

Santosh V 116 Reputation points
2021-08-12T15:57:57.367+00:00

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

122758-project-online-ssis.png

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
    2021-08-13T01:13:18.347+00:00

    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

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Santosh V 116 Reputation points
    2021-08-13T03:33:50.747+00:00

    Thanks a ton Zoe. I will check and update.

    Thanks again


  2. Santosh V 116 Reputation points
    2021-08-17T04:11:11.203+00:00

    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

    123755-project-online.png


  3. Santosh V 116 Reputation points
    2021-08-17T14:52:20.16+00:00

    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

    0 comments No comments