Locked table?

  • I have many dts packages that run fine and one that hangs (Sleeps forever or until I stop it).  The only difference in the DTSs is in the tables they add records into.

    Question:  If my table (target) is getting locked up (In sql server) what might be causing it and what should I do to unlock?

  • How have you ascertained that the table is been locked up? Are you talking about Table Locks?


    Kindest Regards,

  • Table locking is very tricky and simple in sql server if you understand it. First check table locks using sp_lock and see if actually table is being locked or use the enterprise manager to check the locks. If table is actually being locked then kill the spid and run the DTS package again, if this happens again then  check the sequence of your transactions in DTS package and try to change the sequence of the transactions. For some transactions sql server will put a lock itself to make sure the transactions are executed compeletly.

    Hope this helps!!!!

    taj

     


    Tajammal Butt

  • I met the same problem too, when I ran the DTS package which loads many data into the database. some time the DTS hungs forever, and the job is in 'executing'  status always. But It can run correctly after I stop it and start again. I don't know what kind of problem can trigger the DTS package pending forever. actually I saw all the session was sleeping before I stop it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply