I am encountering concurrent update error when using OLE DB command to execute a update procedure in SSIS.
Below is the segment of code which will check for concurrency update. Currently I removed this segment of code in order for my procedure in SSIS to execute successfully. But should I have this segment of code? Otherwise will I encounter concurrency error?
IF @@ROWCOUNT = 0
BEGIN
RAISERROR('ConcurrentUpdated', 16, 1)
RETURN @@ERROR
END