SSIS OData source to Sharepoint stopped working, where is the config file for SSIS OData Source?

James Mc 5 Reputation points
2023-11-29T10:28:08.9266667+00:00

We extract data from Sharepoint lists using SSIS. We use an OData source. It stopped working on the 10th Nov 2023 with the following errors:

Data Flow Task:Error: OData Source failed validation and returned error code 0xC020801F

and

Data Flow Task:Error: Cannot acquire a managed connection from the run-time connection manager

We have applied the registry keys HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32  (on my machine and UAT and Production server)  I tried changing it to the 64 bit but it always says it is the 32 bit version.

Changing the connection to http rather than https or changing Run64BitRuntime to False returns the same errors.

When we test the connection in SSIS we get the error

Root element is missing. (Microsoft.SqlServer.IntegrationServices.ODataConnectionManager)

In other forum posts it says to check the xml config file, but I can't find it. I can find xml files for other connections but not this. There are dll files, but not an xml. Should it exist as an xml file and if not how do I deal with the root element missing error?

We are using Microsoft Visual Studio Professional 2019

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,381 Reputation points
    2023-11-30T05:54:53.2166667+00:00

    Hi @James Mc,

    Could you please try to a repair of Visual Studio?(launched the VS installer, and then did a More | Repair)

    If this does not work, try to create a new package and then follow the article to see if you could use OData source or not.

    OData Connection Manager

    Regards,

    Zoe Hui


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

    0 comments No comments