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

Question

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.

Answer 1

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.