Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), deadlock Rss

   Items 1 to 1 of 1   
 

A deadlock was detected while trying to lock variables in SSIS

Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error  Read more...
By Additional Articles 2010/08/26 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,540 reads
   Items 1 to 1 of 1