InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:34:29 GMT20http://www.sqlservercentral.com/Forums/Topic1382057-148-1.aspxYes.Thu, 08 Nov 2012 10:22:10 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1382057-148-1.aspxok.can i check in lookup with 2 columnfor example productid and productname both should match .not OR.Thu, 08 Nov 2012 08:35:15 GMTharri.reddyhttp://www.sqlservercentral.com/Forums/Topic1382057-148-1.aspxIf 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.Wed, 07 Nov 2012 12:11:34 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1382057-148-1.aspxhiia 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 inserthwo to do using ssisWed, 07 Nov 2012 09:33:44 GMTharri.reddy