import data from Oracle to SQL server

[Asteroid]

Hi Guys,

we need to import data from oracle server to SQL server on daily basis.
let me clarify the problem, we have Oracle database on a LIVE system which is being updated with new rows on a very high rate (Its a telecommunication application), so we don't want to query select statements so often to avoid any possible probelm.

We have another database .i.e MS SQL server, we need to import data from Oracle to MS SQL server on daily basis during late night hours when pressure on Oracle is bit reduced.

I need suggestions and comments how best we can do it, I have heard a bit about MSSQL transformation services. Will this help us or any C# program to update data on MS SQL from ORACLE.

Thank you
@Asteroid

[rmiao]

Which version of sql server do you have? Take look at dts (sql2k) or ssis (sql2k5 and sql2k8).

[Asteroid]

Hi, It is SQL 2k

[rmiao]

Then check dts.