SSIS with Oracle Instant Client 11.2
Installation
- Download ODAC112040Xcopy_64bit.zip to your computer.
- Extract file and Install with command with administrator.
install.bat all c:\oracle odac
- Download instantclient-basic-windows.x64-11.2.0.4.0.zip and extract to
c:\oracle\instantclient_11_2
- Set environment name
PATH=C:\oracle\instantclient_11_2
TNS_ADMIN=C:\oracle\network\admin\sample
- editor
tnsname.ora
# <alias> = Name to use in the connection string Data Source
# <hostname> = name or IP of the database server machine
# <port> = database server machine port to use
# <sid> = name of the database service on the server
<alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = <hostname or IP>)
(SID = <sid>)
)
)