October 24, 2004 at 4:06 pm
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?
October 24, 2004 at 9:09 pm
October 25, 2004 at 9:06 am
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
October 26, 2004 at 10:58 am
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