deadlock error on User::PackageLogID in Task SQL – LogVariableValueChanged
I am getting the error below. I have gone over the book several times and cannot see what I am doing wrong. The error does not seem to adversely impact the operation of the SSIS package, but I would like to get the problem fixed. Other procedures use the same variable without a problem. It is only on the Task SQL – LogVariableValueChanged.
Task SQL – LogVariableValueChanged
Error: A deadlock was detected while trying to lock variable "User::PackageLogID" for read access. A lock could not be acquired after 16 attempts and timed out.
[SQL Task] Error: Variable "User::PackageLogID" does not exist.