SQL Server Performance Forum – Threads Archive

dead lock error when execute DTS Package

Hi, i have created a DTS Package in which i call a stored procedure.
when i execute the package i got an error in the middle as below.
(consider the DTS package run 3 hours to complete the execution,
the error im getting after 2 hrs of process, meaning i get the work done partially).
"Transaction (Process ID 73) was deadlocked on lock resources
with another process and has been chosen as the deadlock victim.
Rerun the transaction. (Microsoft OLE DB Provider for SQL Server (0):" why is this error happened?.
do i need to clear deadlocks for every time i execute DTS package?.
then how to clear deadlocks?
is there anything to do with SP_LOCKS or SP_WHO before i run DTS?.

---

http://sql-server-performance.com/deadlocks.asp Madhivanan Failing to plan is Planning to fail

---

]]>