Migrating from Oracle to Sql Server

Question

Hi all I need to create a new db in Sql Server, and move some data from an Oracle db to this Sql Server db; I read that this function can be implemented by using SSIS or the SQL Server Migration Assistant for Oracle; I wonder if someone can point me to a tutorial or a document where I can see how this task is performed step by step

The data moved from the Oracle db is updated on a day basis, so the data moved has to be updated regularly

Many thanks in advance for your help guys

Answer 1

Have you looked at the SQL Server Migration Assistant for Oracle?

Step by step document on how to use it.

Answer 2

How about this:

http://aspalliance.com/947_building_a_sql_server_2005_integration_services_package_using_visual_studio_2005

and this:

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