We have DTS package with isolation level of 'read commited'.
In this is a vbscript task that opens a recordset and loops through it.
Question: is it possible that the rows in the recordset get updated by tasks
outside DTS (website SQL updates) as it is looped through, or is the
recordset fixed as soon as it is opened?
What is happening is the recordset is based on SQL 'WHERE column IS NULL'.
Then every primary key read is strung together for an IN (key1,key2) clause
for an UPDATE statement later. However UPDATE statement updates different
number of rows than were read in loop.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".