Share via

Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS

Amogh Sharma 45 Reputation points
2024-07-18T15:55:39.1166667+00:00

Hello,

So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see a preview with all the rows and columns I will be importing as well as column mappings with all the information I need to import. For the destination I am using the OLE DB Destination to connect to a database on my machine's local server and create a new table to populate with the imported data. Everything is good in compile time but on running the data flow task, I get these errors:

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.

I have attached images for reference. Any help is appreciated.

Screenshot 2024-07-18 121353

Screenshot 2024-07-18 121440

Screenshot 2024-07-18 121508

Screenshot 2024-07-18 122636

Screenshot 2024-07-18 122723

Screenshot 2024-07-18 123420

Screenshot 2024-07-18 123429

SQL Server Integration Services
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

SQL Server | Other
0 comments
Answer accepted by question author
  1. ZoeHui-MSFT 41,551 Reputation points
    2024-07-19T06:23:08.1566667+00:00

    Hi @Amogh Sharma,

    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

    If this does not work, try to re-add the connection manager or set it to 64bit runtime under properties in VS for a try.

    Regards，

    Zoe Hui

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

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Walid AZAK 0 Reputation points
    2026-04-01T14:12:24.6533333+00:00

    It works with basic authentication, but in production we use Windows authentication, which causes the process to fail. can you help me

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.