Hi,

I have 3 separate DTS package which have the simple task
of transferring new data from Server A to Server B on a
daily basis by using the following query in the data
transformation task properties 'Source' tab:

select A.*
from SourceTable A
left join DestTable B
on A.PK = B.PK
where B.PK is null

(then choose destination table etc...)

All packages are scheduled to run between midnight and
1:30 am. DTS Package 1 runs succesfully but the other 2
never ever complete; when I come to work at 9:00 they are
still showing as 'executing step 1' after 8 hours! SQL
profiler doesn't reveal anything except maybe that
sp_help_job is run regularly. Server A and B are linked
using a SQL Login having the relevant permissions. I don't
think it's a permission issue anyway, as Package 1
executes without any problems.

When running the other 2 packages in QA (i.e. run the
query above with an extra 'insert' statement) then the job
gets done in just over 1mn.

Does anyone know what might be causing this behaviour? I
think it will be to do with server B, as I have many other
similar DTS packages running perfectly well on other
servers.

Many thanks for your help.

Elisabeth