I'm modifying an SSIS (SQL Server 2008 R2), which originally had a Script Task that did two different things, which I divided into two Script Task. Both have some common variables and when they execute they return the following error:
A deadlock was detected while trying to lock variables "User::Variable1, User::Variable2, User::Variable3, User::Variable4, User::Variable5" for read access and variables "User::Variable6, User::Variable7, User::Variable8, User::Variable9, User::Variable10, User::Variable11" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out.
Is there any way to avoid this? I understand that the "ñapa" is that each task has its variables, but that enguarrina much.