November 7, 2012 at 9:33 am
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
November 7, 2012 at 12:11 pm
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.
November 8, 2012 at 8:35 am
ok.
can i check in lookup with 2 column
for example productid and productname both should match .not OR.
November 8, 2012 at 10:22 am
Yes.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply