all, we are planning a data migration pretty soon. The way we have the source database(Oracle 9i) setup is we have to always log on a separate client network(say network A). We are provided with a separate laptop, which allows us to VPN on to their network. I wonder what does the client have to do, at their end, to let me have connected to the database through SSIS(which is on the network B)? to me more clear, do the client newtork have to open a port, or a dblink,or do I create linked server? I am not sure what are the requirements at the db level and at the network level that, i could use Oracle as my source, which is on the diffferent network? i am dealing with 2 differnt networks and two different machines for each of the network.
You should discuss this with the network administrators. What need to be able to connect to the Oracle Database from the machine on which the SSIS packages will be executed. So generally you have to be able to connect to particular port on machine on which the Oracle is Running. - Default port for Oracle is 1521. So if Oracle has default configuration, you need to be able to connect to this port. Once you are able to reach the oracle, you can connect to it aby using any method.