April 28, 2006 at 11:47 am
Hi, I am trying to connect to an Oracle source in SSIS using Microsoft OLE DB Provider for Oracle. Unfortunately, I have no Oracle experience. The Oracle Database\server is on someone's local machine at my company.
I read that you need to use the alias from the tnsnames.ora file. Do I need to copy that file locally? Where do I put it?
Any information regarding this would be greatly appreciated.
Thanks,
Daniel
April 30, 2006 at 11:57 am
If you install the oracle client tools from you SSIS machine, I think the default location is:
c:\oracle\ora92\network\admin\tnsnames.ora
One of my entries looks like this.......
fully.qualified.server.name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.678.901)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = another.fully.qualified.server.name)
)
)
And then you connect to "fully.qualified.server.name" in SSIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply