I am attempting to use package configuration for an SSIS package that uses an OData Connection manager.
I am using SSIS 2019 and Visual Studio 2022 running on Windows 10.
I am running the following versions of the .NET Framework
=== Installed .NET Framework Versions (Classic) ===
Framework Version Release
--------- ------- -------
v2.0.50727 2.0.50727.4927
1033 3.0.30729.4926
1033 3.5.30729.4926
Client 4.0.0.0
1033 4.8.09037 533325
The package is pretty basic, and the OData Connection Manager is to SAP.
I am also using package configuration for the connection string to the OData Resource
During design time, the OData Connection Manager test fine and the associated OData Source works correct. I am able to get data out of the specified source.
However, when I execute this, the package fails during run-time (In Visual Studio Debugger and Command Line using dtexec):
[(OData Source) [141]] Error: Cannot acquire a managed connection from the run-time connection manager.
[SSIS.Pipeline] Error: … (OData Source) failed validation and returned error code 0xC020801F.
I tried a variety of different changes:
- Setting the Protection Level to “DoNotSaveSensative” – when I do this I see the password is not being set.
- Connection Manager – Set to “DelayValidation”
- OData Source – turned off “ValidateMetaData”
Here is where it gets strange. If I use Fiddler, and have it decrypt the payload, I can see the payload but the SSIS package runs successfully. If I stop Fiddler, then the package fails during runtime
This tells me it is something with TLS encryption. I have tried a series of Regedit changes and have updated the .NET Framework as other posts recommend but to no avail.
I am not sure what to do next but any assistance would be appreciated