how to insert data from sql server 2000 to a table that is located on oracle 10g?

hi all,
i have to retrieve data from sql server 2000 and put them into a table which is located on oracle 10g.
i dont know how to achieve that. do you have any idea? using c# application?

thanks
viola
LVL 6
viola123Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chapmandewConnect With a Mentor Commented:
You should be able to do this using DTS.  Right click the SQL Server db , select tasks, then import data.  From there you can select the Oracle server as your source...a wizard should guide you through the rest.
0
 
viola123Author Commented:
hi all,
thanks a lot. i am currently using c# application to do that cos i have to make sure every record is exported correctly and log the failed ones. but DTS can do that as well.

thanks
0
All Courses

From novice to tech pro — start learning today.