can a single task read, update and lookup on same table ??? -- sql server dts

Antonio Lopez Arredondo
5/6/2004 8:12:27 PM

hi all !!!

I have two diifferent tasks that reads from table XYZ, does a lookup at the
same table XYZ and finally updates also table XYZ. in order to avoid
deadlock situations I use "with(nolock)" where ever possible (source query
and lookup).

both tasks run independently (at different times) and show different
behavior:

* one of them never starts, its status remains as "started" and never
changes.

* the other one starts and processes 1000 records, then it seems to stop
working (no error, no advance).

any light on what could happen is very welcome.

best regards,
ant.

Allan Mitchell
5/7/2004 8:55:21 AM

Why would you need to perform a lookup on the same table. Your Query itself
should be taking care of that. As for why it seems to hang then yes I would
definitely suspect blocking.

Does sp_who2 have any entries in the blkby attribute?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : can a single task read, update and lookup on same table ???