I have spent the last two weeks banging my head on why I couldn’t get Oracle password to save in the SSIS package despite using the config file or decrypt and a multitude of other options. 234 more words
Tags » Oledb
I nearly pulled my hair out finding the solution to this problem.
In the end I installed “32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio” on my 64 bit system, and it solved the problem. 27 more words