The steps to get the Oracle database are as follows:
1. The target server gets the connection Oracle database permissions
2. Install the Oracle client with the name Win32_11gr2_client installation Administrator version.
3, put the configuration file Tnsnames.ora under D:\app\Administrator\product\11.2.0\client_1\network\admin, and Tnsnames.ora contains IP, Port number and service name (SID)
4, SSIS uses OLE DB to connect the Microsoft OLE DB Provider for Oracle server name to write Tnsnames.ora service name
Troubleshooting: If the Oracle client installs the wrong version of the ORA-01019 error, you need to modify the environment variable to remove the wrong path after the installation is correct, and then restart the system.
Reference:
Http://www.111cn.net/database/Oracle/43838.htm
http://blog.itpub.net/4227/viewspace-621993/
SSIS obtains Oracle database data