I currently have a DTS task that is failing on one step due to more locks being allocated than are available.

I therefore changed the step to ensure that a table lock is placed on the table. However, now the step doesn't seem to run at all. The step starts but after waiting for 20 minutes no rows were copied across - whereas before I was experiencing the locking problem that step would take about 2 minutes.

I have since managed to work around this problem by creating a SQL Task that does an insert. This works fine.

I am curious to know why the step was not working with a table lock specified, and was wondering if anyone has come across this before.

Regards,

Karl