SQL Server - Intra-query parallelism caused server command to deadlock

while running a dts package, i found this error
step error description: Intra-query parallelism caused your server command to deadlock.
step error code: 80004005

basic thing to do is to re-run the dts(in turn re-running the query)
but, this failure has been occuring again and again after every few days.

I'm clueless here what to do, how to find the query or part of query causing the deadlock or the table affected or causing this deadlock. I'm unable to detect the deadlock. I would be very grateful if someone can help how to detect where the deadlock could be. Also, how to solve the problem.

Unless you have a looping portion on different nodes, you should have the ability to step through each node in the DTS package. This is done by right clicking on the node and selecting Execute Step. You then receive a message box identifying the success or failure of that specific node.