CODEWITHSUNDEEP
sql-serverssisodataetl
Vinh Ton
Vinh Ton

Reputation: 107

Odata: Cannot acquire a managed connection from the run-time connection manager

Problem

Get the error (see below) when executing an SSIS Odata connection to the Medicare Data site despite successfully previewing data.

Tried

enter image description here

SSIS Error in Debug

Error: 0xC020801F at data convert, OData Source [21]: Cannot acquire a managed connection from the run-time connection manager. Error: 0xC0047017 at data convert, SSIS.Pipeline: OData Source failed validation and returned error code 0xC020801F. Error: 0xC004700C at data convert, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at data convert: There were errors during task validation.

Upvotes: 2

Views: 6738

Answers (2)

Vinh Ton
Vinh Ton

Reputation: 107

Turns out its a really dumb thing: use http instead of https despite the Medicare site reference to https

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/72a5752a-22e5-4542-97c3-7a4044e0fea5/ssis-odata-source-works-in-development-but-fails-when-run-0xc020801f

Upvotes: 1

J.D. Walker
J.D. Walker

Reputation: 166

Can you open the SSIS package from within Visual Studio shell, and then look at the oData connection and test it? I'm having a similar problem, and when I test my connection, I'm getting an Internal Server Error (500) returned from the SharePoint server where I'm trying to connect.

Upvotes: 0

Related Questions