How to resolve this eroor in script task using ssis package

Question

0.00/5 (No votes)

See more:

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

What I have tried:

Could please suggest me how to resolve that eroor.

Posted 2-Aug-17 0:10am

botchu

Updated 2-Aug-17 0:36am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2017-08-02T00:36:00

Solution 1

This can't be solved without seeing your code but you might forgot to call Unlock somewhere or uses locking for long tasks.

Maybe Todd McDermid's Blog: Use ReadOnlyVariables and ReadWriteVariables properties in Scripts[^] is helpful because it explains how to avoid locking at all.

Posted 2-Aug-17 0:36am

Jochen Arndt

How to resolve this eroor in script task using ssis package

1 solution

Solution 1

Add your solution here

Preview 0

How to resolve this eroor in script task using ssis package

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us