Primary key constraint error

David Paras

• May 21, 2012 19:59

If there is a process flow where I have a source file which may have new records as well as the once which are already existing in the database. Now I would like to only insert the records and skip the update records.

Right now in the database target I have only insert selected. But then if it finds a record which is already there it fails because it sees duplicate primary key. I would like the process flow to continue inserting records and skipping the update records instead of primary key constraint error and stopping the process. How do I do it?

0

• 

  David Paras

  • May 21, 2012 20:01

  This can be easily done you have to just take care of below two things:

  1. While Creating Database Target Select "Database Operation" as Insert.

  
  2. In Process Flow Double click on Database Target activity and Select Error Records as "File' from dropdown.

  

  0

Post is closed for comments.