- 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
worked fine.

- 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?