Though I did execute the dts on the server itself... its a point that I did not know..

will remember that

Thanks a lot

I looked up BOL.. looks like just what I need

However it says the usage is not recommended ..

Did not mention any alternative of doing the same thing..

Thanks a lot...

Turns out that the persormance was affected because the db needs some tuning...

Thanks

Am I wrong in assuming that it can never happen?

If so under what circumstances can it happen?

Thanks in advance

Yes thats true.. if I understand correctly then you mean to say that the lock is there because the task is waiting for the previous task to complete. Ok.. I...