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.
|
