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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply