0

Differentiate between update and insert using upsert

Aimsamcdev

April 01, 2011 21:23

None

Follow

Hi There,

I have a requirement where I am importing records from a flat file. I need to update the record in destination SQL table if the primary key already exists else I will need to insert. There are 2 columns I need to update here. InsertDate and UpdateDate. If I Insert a record, I want the column "InsertDate" to be current Date and time, and the UpdateDate to be "01/01/1900". If its update I do not want to update the "InsertDate" column. But the UpdateDate should be currentDate and time.

How do I achive this? Do I need to build expression for this?

Thanks.

 

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Aimsamcdev April 01, 2011 22:17

  My Primary key is a combination of 2 columns. If that helps.

• 0
  
  Aimsamcdev April 01, 2011 23:47

  I have this function where I can specify a condition and Then and else values depending on the condition if true or false. I am not getting how to find if the current record being processed already exists in destination table or not. How do i build that condition? What tool do I need to use?

   

  Thanks,

  Neela

• 0
  
  Mike O'Quinn August 02, 2011 21:54

  Use the "Diff Processor" transformation.  This will give you two outputs, one for new records and one for updates.  You can control the mapping in each output.