Best way to get the data from oracle to SQL sever using SSIS

• suriraja

  Valued Member

  Points: 69

  More actions

  March 5, 2009 at 10:34 am

  #197677

  Best way to get the data from oracle to SQL server for the below scenario using SSIS.

  Table A -Oracle

  Table B –SQL server

  Select * from A

  Where a.col1 in (select b.col1 from B)

  Oracle table has 5crore+ records and SQL server table has around 50 records

  The result excepted is around 35 to 40 records (or max 100).

  I have read only access on oracle server.

  Thanks in advance

• guptaopus

  SSCommitted

  Points: 1534

  More actions

  March 9, 2009 at 3:06 am

  #955835

  Hi,

  You can try this

  Select col1 from A

  INTERSECT

  select col1 from B

  It will give you resultset of A where col1 which are present in B