SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle".

I am using "Export Data..." option from Task menu. 

I get to connect to the source database (SQL Server) but when I try to connect to the destination database (Oracle) using "Microsoft OLEDB Provider for Oracle" option, I get the following error.

"ORA-06413: Connection not open"

I also checked my connections (tnsnames.ora) and I am able to successfully connect using  SQL Developer to my local Oracle XE instance. My OS is Windows 8 running on a x64 machine.

Any guess what could be the problem here?
I would try installing the Oracle Data Access Components (ODAC).

You will be able to download them from this link. 
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html