Search code examples
sql-serveroracle-databasessismigrationtransfer

Migrating Oracle Table partially to SQL Server using SSIS

I am new to SSIS and I will jump right in:

Requirements:

  • Migrate table data from Oracle to SQL Server using SSIS
  • One of these tables has 50+ million rows on the source, only migrate X number of rows based on a a date column, no staging tables allowed

What has been accomplished:

Data flow has been created, currently all rows and all tables migrate without issue.

What remains to be done:

This one particular table needs to be partially imported. How can I do this keeping the requirement in mind. The requirements are firm, SSIS a must and no staging tables are permitted.

Thank you

Solution

  • Within your Data Flow, I would edit the Data Source object for that particular table. There I would design a SQL statement e.g.

    SELECT * FROM mytable WHERE mytable.datex >= to_date ( '2014-01-01', 'yyyy-mm-dd' )