Post reply

How to pick only those records from Oracle which are not present in SQL Server

  • November 13, 2013 at 9:58 am

    #282457

    I am using SSIS to fetch records from Oracle into SQL Server 2012.

    This is the first time I am using SSIS. I created a new package and was able to fetch all records from one table of Oracle into another table of SQL Server which is fine. But now I want to place a condition in between i.e. if a record is already present in SQL Server then do not insert.

    And if record is not present in SQL Server then insert it with date and time when it was inserted.

    Consider the following structure:

    Oracle

    Table: oracle_table

    Fields: my_id, my_name

    SQL Server

    Table: sql_table

    Fields: id, name

    So I want to check if some id is already present in SQL Server then do not insert otherwise insert with date & time. Currently it is fetching all records.

    I tried to use Lookup but couldn't make it work.

  • November 13, 2013 at 11:12 am

    #1666163

    Please check this post. I am stuck.

  • November 13, 2013 at 12:00 pm

    #1666179

    I added Lookup between Oracle source and SQL Server destination. So basically first is Oracle which is connected to lookup and then it was connected to SQL Server.

    I am in Columns tab of Lookup and can see two tables to select.

    In "Available Input Columns" I can see the fields from Oracle while in "Available Lookup Columns" I can see fields from SQL Server.

    Now what?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply