Error in SSIS Package Execution - An error occurred when detecting the document payload kind (Microsoft.SqlServer.ManagedDTS)

Question

I am encountering an issue in a SQL Server Integration Services (SSIS) package execution, and I would like to report the error for further investigation. The error message is as follows, URL sample Uhttp://your-hana-server:port/sap/opu/odata/sap/MyService/Customers Unable to load collection for the connection OData Source, reason: Cannot open this connection

Unable to load collection for the connection OData Source, reason: Cannot open this connection

===================================

An error occured when detect the document payloadkind. (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

   at Microsoft.SqlServer.IntegrationServices.OData.ODataConnectionManager.AcquireConnection(Object txn)
   at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(Object txn)
   at Microsoft.DataTransformationServices.DataFlowUI.ODataConnectionPage.LoadCollections(ConnectionManager connectionManager, List`1& collectionList)
   at Microsoft.DataTransformationServices.DataFlowUI.ODataConnectionPage.LoadConnectionCollectionBody(Object arg)

Answer 1

Hi @Prabhu,

Check below article to enforce use of TLS 1.2 to see if it is helpful.
https://learn.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/tls-issue-with-ssis-package-while-accessing-odata-source-like-dynamics-ax-online

Regards，

Zoe Hui

---

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