data exists

• harri.reddy

  SSCommitted

  Points: 1957

  More actions

  November 7, 2012 at 9:33 am

  #393551

  hi

  ia m getting data from 2 excel file ,that i need to merge and then load into destination table.

  but before file load i need to 1 number from 1 file, if it is already exists in the database, i dont need to insert that rows,if not i need to insert

  hwo to do using ssis

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  November 7, 2012 at 12:11 pm

  #1556896

  If you have some sort of ID column, use a lookup transform to lookup data that is already in your table and match it to the data coming in from Excel. Configure the lookup transform to ignore errors and then use the No Match precedence constraint to connect to your destination table.

• harri.reddy

  SSCommitted

  Points: 1957

  More actions

  November 8, 2012 at 8:35 am

  #1557211

  ok.

  can i check in lookup with 2 column

  for example productid and productname both should match .not OR.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  November 8, 2012 at 10:22 am

  #1557277

  Yes.

  ---