Microsoft SQL Server Integration Services : Error code 0x80004005
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Transaction (Process ID 135) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.".
Solution:
Add WITH (NOLOCK) on OLE DB Source query to release lock on table being queried. Lock occurs if 2 or more processes are waiting for a resource and neither can advance because the other process is preventing it from getting the resource.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment