Common client to transfer data from 2 oracle versions to SQL Server 2005

[Osho4U]

Hi,
I have two database servers on different machines. They are
1) Oracle 8.1.7.4
2) Oracle 7.3.1.4
I have to create agents which can transfer tables from these two databases to one machine having sql server 2005 database.

Please tell me what are the options. What drivers i need to install on machine having sql server 2005 so that i can transfer data from both oracle versions.

Thanks
Rajneesh.

[skhanal]

You can use SQL Server SSIS to transfer data from Oracle to SQL. You need to install Oracle 8i client in the machine running SQL client.