title: SSIS Logging of OnVariableValueChanged with variable value
body: <p>I am trying to log all changes in variable values in a SSIS generated with BIML.
  I managed to create an event handler that writes everytime a variable changes its value.
  When I log I use a parameter whose value I set to "System.VariableValue". I pass this parameter (togheter with variableName and PackageName) to a StoredProc and i write in a log table.
  My problem is that often (but NOT always) it seems the parameter does not has any value. I see a new line in the DB Log table so this means the evnt is correctly raised and handled BUT it seems the parameter is empty.
  The strangest thing is that sometimes values are logged correctly but not always, not for the same variables, not for the same packages, rather, in a quite random fashion.</p>
  
  <p>Could it be a problem the fact that several variables could change value almost at the same time (some contention on the DB) ? I doubt it, because the row itself gets written on the DB. I even tried to write, as a value, something like 'New value = ' + ?   that is, appending the parameter value to a fixed string. The fixed part gets written correctly but.. no value.
  The name of the variable that changed value is always written correctly.</p>
  
  <p>Any idea what this could be due to?</p>
  
  <p>As a workaround I tried to use the ready-made logging facility of SSIS but in this case in the message column of the SYSSSISLOG table i can just read the name of the variable that changed, not its new value.</p>
  
  <p>thankx</p>