Why should we lock variable before access it in the script task

• sharmili.net

  SSC-Addicted

  Points: 451

  More actions

  October 12, 2013 at 1:37 am

  #278070

  Hi everyone,

  Could you please tell me Why should we lock variable before access it in the script task?

  Thanks in advance,

  Sharmi

• aaron.reese

  SSChampion

  Points: 13498

  More actions

  October 22, 2013 at 3:57 am

  #1660428

  sounds like homework to me...

  You want to lock the variable so that no other process can change the value whilst your script runs, otherwise any logical processing you do may be affected by the change in value leading to unexpected results which woudl be really difficult to debug.

  Also, I am not sure that you can change the value of a variable within the script unless you have it locked for write.

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  October 22, 2013 at 4:59 am

  #1660439

  aaron.reese (10/22/2013)

  ---

  Also, I am not sure that you can change the value of a variable within the script unless you have it locked for write.

  I never lock variables. Never ran into an issue either.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP