Insert or update depending on if new Id or the existing one.

• pranav.thakur

  Old Hand

  Points: 398

  More actions

  December 10, 2008 at 4:35 am

  #129212

  Hi,

  1)I am using a "Flat File source" for taking input from CSV file.

  2)Using "Lookup" and "condition Split" control I am checking if the Id from CSV file is a new Id or an existing Id.

  3) If there is a new Id , I am inserting the record using "SQL Server Destination"

  4) If an Id from CSV file already exist in the database table, I have to update the row corresponding to the Id.

  I have done the first 3 steps but I am struggling with the last one. Which control I should use as destination to update the database table.

  Please help.