We have a DTS package that uses a DDQ to send email and update a table. The
package is updating the same table that it is selecting from, therefore the
source table and the binding table are the same. Also, the update query is
calling a stored procedure to send the email and update the table.
Occassionaly, the package hangs in the DDQ task and it appears to be
deadlocked against itself. Could this be caused by using the same table as
the source and binding table?

Thanks,
Michael

Quite possible. Can you move the update to a different table? Maybe just
have a control table.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!