0 Replies Latest reply: Feb 12, 2012 2:14 AM by 891464 RSS

    Migrating SQL Server SSIS package to Oracle

    891464
      Dear All,

      We are using Microsoft SQL server 2005 in our application, we have two separate Server instances where one instance synchronize data from other server table using SQL Server SSIS package. What can be the counterpart of this functionality in Oracle. I have looked into materialized views but in my case the target table will have more columns than the base table, and the query used to get data from base table will extract some values from one of the BLOB type column of base table and then populate target table multiple columns.

      Kindly suggest me any solution.

      Best Regards

      Irfan