SSIS - Variable lists for the script task are case sensitive
I've just been tearing my hair out trying to get
variables and locking working. It was only after one of those eureka moments
that I realised that the variable names are case sensitive.
So the lesson learnt is make sure that you have a naming convention for your
variables so you don't have to remember if your variables are all lower case
(unreadable) , title case (my preference) or camel case.
I've also decided that I prefer to use the lockForWrite over the
LockOneForWrite and even over specifying the names in as a delimited list. The
reason being is that you have the better control in doing it that
way.
-