question

SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 asked SantoshV-2219 answered

Unable to extract OData to SSIS

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @SantoshV-2219

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 answered ZoeHui-MSFT commented

Thanks a ton Zoe. I will check and update.

Thanks again

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SantoshV-2219
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·
SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 answered ZoeHui-MSFT commented

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



project-online.png (38.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SantoshV-2219, i saw that you have raised the question to sharepoint side which will help to get professional advice.
I did some online research, not sure if this could be useful, you may take a carefully reference:


0 Votes 0 ·
SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.