Migrating from Oracle to Sql Server

Question

I need to create a new db in SQL Server and transfer some data from Oracle db to this db SQL server;

I read that this feature can be implemented using SSIS or SQL Server Migration Assistant for Oracle ;

I wonder if someone can point me to a tutorial or document where I can see how this task is carried out step by step.

Data migrated from an Oracle database is updated daily, so migrated data must be updated regularly.

Answer 1

SQL Server Oracle?

, .

Answer 2

:

http://aspalliance.com/947_building_a_sql_server_2005_integration_services_package_using_visual_studio_2005

:

http://msdn.microsoft.com/en-us/library/ms169917.aspx