Thanks Sue! Working on this for last two days scratching my head no luck. Still don't want to give up. I tried everything i could think of. Installed the 64 bit client. Using Net Configuaration assistant configured the Local Net Service Name and it connects successfully form there. However, when i go back and try to connect from SSIS using Oracle Destination and then it doesn't work.
There was an error trying to establish an oracle connection with the database server.
Not sure what i am missing here?