I recently added another SSIS package to my existing project that I upgraded from VS 2017 and its associated ODT VSIX extension. I thought everything was working nicely, however I am stuck in what seems to be DLL hell. I looked at the devenv.exe.config and it lists Version 4.122.19.1, however when I went into the VSTAProject that I add my code to I need to add/update my reference to the Oracle.ManagedDataAccess assembly. When I browse to add the reference I end up finding the file that came with the ODT VSIX extension, however it's version 4.122.21.1.
The problem I'm encountering when I try to execute the SSIS package is System.IO.FileNotFoundException: Could not load file or assembly Oracle.ManagedDataAccess, Version=4.122.21.1 or one of it's dependencies.
Has anyone else encountered this, I can't seem to get around it right now?