Oracle SQL DTS
Posted on 2004-08-31
How I can move data from Oracle to MS-SQL?
My first idea are use DTS from MS SQL, but I cant stablish the communication between servers.
The TNSNames.ora is like:
(ADDRESS = (PROTOCOL = TCP)(HOST = SRV1)(PORT = 1521))
(SERVICE_NAME = INFO1)
Can you explain me how I can stablish a connection from a DTS?