DTS Oracle->SQL2000, who connects to ora?
- Using the wizard from SQL Enterprise Manager on a client PC I set up and
run a DTS package to import tables from a Oracle DB to SQL Server 2000. It
- Some investigation showed, that the connection to the Oracle Server was
made from the client PC (I think by SQL*Net), not from the SQL Server. Surprise!
- In case I want to schedule this package, the connection to Oracle definitely
has be made from the SQL Server. Right?
How can I influence in DTS, who connects to Oracle (in this example), as
long as I start the job in EntManager from my WS?
I assume: if I am sure, that the connection from the SQLServer to OraServer
works, it also should be easy to setup Oracle as a linked server in SQLServer?
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center