Getting error deadlock detected while waiting for resource.
Posted: Fri Mar 28, 2008 2:22 am
Hi,
I am using one source table,one lookup table and finally in the end i am using the same source table to update the records.
I am getting error in the job as deadlock detected while waiting for resource.
What properties needs to be set in the stage so that it will not keep source table locked?
As in server jobs if we are useing the same table as look up and update we set its property as Read Uncommited.
Like this is there any property in parallel ?
Thanks in advance.
Nilesh
I am using one source table,one lookup table and finally in the end i am using the same source table to update the records.
I am getting error in the job as deadlock detected while waiting for resource.
What properties needs to be set in the stage so that it will not keep source table locked?
As in server jobs if we are useing the same table as look up and update we set its property as Read Uncommited.
Like this is there any property in parallel ?
Thanks in advance.
Nilesh