Share via

In SSIS (version 15, created through Visual Studio 2017), I am trying to connect to a Sharepoint list ("Deficiencies") with an HTTPS URL. I get this error:

Richard O'Carroll 0 Reputation points
2024-03-23T21:24:40.6533333+00:00

I am trying to get the sharepoint list using oData Source service using Basic Authentication. The connection test okay and i can preview the data.

Connection String

https://XXXXXXXXXXXXXXXX/_vti_bin/listdata.svc/

But when i run the package, it will error with following error message

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Error: 0xC020801F at Data Flow Task, OData Source [2]: Cannot acquire a managed connection from the run-time connection manager. Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: OData Source failed validation and returned error code 0xC020801F. Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. SSIS package "C:\Users\richard.ocarroll\OneDrive - GXO\SSIS\Backhaul data\Backhaul data\Package.dtsx" finished: Failure. The program '[13868] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

It works in preview and the test connection works

I also did the below

reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64

Was hoping to pull the data to a data warehouse but keeps failing

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,551 Reputation points
    2024-03-25T02:14:29.9633333+00:00

    Hi @Richard O'Carroll,

    There is a known TLS issue with SSIS package while accessing OData Source like Dynamics AX Online

    You can resolve this using the below steps:

    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

    Someone also mentioned it maybe a SharePoint set issue, see the answer here.

    User's image

    Regards，

    Zoe Hui

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

    0 comments