dts import give sql server cannot obtain a lock resource

[shresthaal]

i am trying to copy about 100000 records from one table to another using dts
i am using a query similar to this
select x,y,z
from ddtable
where ddtable.id >= val1 and ddtable.id < val2

gives me sql server cannot obtain a lock resource everytime

exec sp_configure gives

5000 213..... 10000 10000

can anyone explain whats going on

 

[JayKusch]

TRY ...

select x,y,z
from ddtable with (NOLOCK)
where ddtable.id >= val1 and ddtable.id < val2

Thanks

J. Kusch