sql server dts: Hello,
I received this error when processing SSIS Package.

Error: A deadlock was detected while trying to lock variables
"User::LoopCount" for read/write access. A lock cannot be acquired after 16
attempts. The locks timed out.

I declared the following my variable also in the code below.

Dim myVar11 As Variables
Dts.VariableDispenser.LockOneForWrite("LoopCount", myVar11)
myVar11("LoopCount").Value = 3

Your help is appreciated,

Hello Lawrence,

Is this in a Script Task? Have you by any chance specified these variables
on the Script Task UI as well as locking them internally like this? You
should do one or the other.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]