New in SQL Server 2012 is a Change Data Capture for Oracle by Attunity which allows you to continually copy data from Oracle to SQL Server. This feature is helpful in two common business scenarios: 1. Migrating from Oracle database to SQL Server 2012 systems - you can synchronize criticial tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server 2012 tables. 2. Data Warehousing using a SQL Server 2012 system. Changes can be capture from your Oracle database and sent to SQL Server 2012 databases to keep the data warehouse in sync.
Download and Setup information:
SSIS Data Flow components and Control Flow task
Troubleshooting Guides