I am having a strange issue working with SSIS OLEDB connection to oracle Database.
When I check the oledb connection manager there is an issue that password is blank. When I enter the password and say 'Test Connection', it says connection successful but as soon as I say OK to close the window with password entered, machine just hangs indefinitely.
Basically I am not able to enter the password for SSIS package.
Any Ideas anyone on what is going wrong ?