Data Driven Query deadlock

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Michael (mwilson_at_nospam.raytheon.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 11:16:54 -0500

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

Relevant Pages

  • DTS LookUps
    ... Can a Look-up be made 'global' to an entire package? ... I have a Data Driven Query (DDQ), built using DTS designer and it has ... How can I make this look-up (or it's functionality) global to the package so ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS LookUps
    ... No. Lookups will be specific to the DDQ you are using. ... Can a Look-up be made 'global' to an entire package? ...
    (microsoft.public.sqlserver.dts)
  • Re: kickstart, installing extra packages
    ... Reading package lists...Building dependency tree... ... Selecting previously deselected package xresprobe. ... Extracting templates from packages: 0% ...
    (Ubuntu)
  • Re: How to pass two dimensional arrays to C
    ... binding will be finished only as my spare time permits). ... package PLplotThin is ... -- but in the thick binding PLplot wrapped in Mesh_3D. ... -- These routines are unavailable from this thin binding. ...
    (comp.lang.ada)
  • CTAN package update: LaTeXPiX
    ... The package described below has been updated on tug.ctan.org and should ... button enables selecting of multiple objects. ... * Added more information and exception handling when the Windows registry ... You may get a better network connection by using a CTAN mirror ...
    (comp.text.tex)