Data Migration from Oracle to SQL Server
You can do this directly from SQL Server Management Studio. 
Within SSMS, just right click the database, select Tasks -> Import Data, select an Oracle typed data source and set up your connection to the Oracle database. 

Here's a really good description of the full procedure, including setting up an Oracle client on the machine doing the migration.

http://dbadiary.wordpress.com/2012/10/04/data-migration-from-oracle-to-sql-server-with-ssms/