Post reply

CONDITIONAL INSERT USING LOOKUP

  • August 7, 2008 at 1:42 am

    #125500

    HOW TO INSERT ROW IN A DESTINATION TABLE

    e.g. source table is having col1 with values 1 to 25 and I insert 26th row , I want only 26th row tobe inserted into my destination table and rest 25 row should be updated with new values from destination if any.

    Pl. help

  • August 7, 2008 at 4:06 am

    #854316

    one way is to use a lookup transformation to compare the incoming records to the destination table. direct the "error" rows (i.e. unmatched) to the destination table and the matched rows send to a holding table.

    Then, use a sql task to run an update from the holding table to the destination table. Clear out (or drop) the holding table after the update has been successful.

    Be wary of the lookup transformation if your destination table has lots of rows; you made need to use the memory throttling. There are a few articles out there that talk about the best way of using this transformation.

    Cheers,

    Tom

    Life: it twists and turns like a twisty turny thing

  • August 7, 2008 at 7:13 am

    #854421

    Thanks It works

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply