View Full Version : Checking the data existance in Database
03-28-2006, 01:35 AM
Is there anyway we can check if the data is already existing in the table where it is going to be inserted
03-28-2006, 01:42 AM
Yes, use the Insert/Update step, it only inserts when the key can't be found.
It only updates when needed.
Hope this help,
03-28-2006, 04:52 AM
Thanks for your reply.But my requirement is that if the data already exists in the table it should skip that particular record and proceed with the next Record.
03-28-2006, 04:55 AM
Well then I guess you need to do a lookup then and check if the returned key value is null or not.
- DB Lookup
04-05-2006, 01:51 PM
Is it possible to create a step like Insert/Update without the update ????
04-05-2006, 01:57 PM
Dude, use a table output!
RTFM I guess ;-)
04-18-2006, 01:15 AM
Ummm... How is this not done by the Insert/Update step? The way I see the Insert/Update step working is this:
1. Check if the record exists - if not, then insert record.
2. If record exists, then update if record contains new information.
3. Otherwise, do nothing.
Is this interpretation correct?
04-18-2006, 01:22 AM
Yes, that interpretation is correct.
The insert/update step has been changed in the mean time to have an insert/update WITHOUT the update, using a flag...