SSIS Logging of OnVariableValueChanged with variable value -

i trying log changes in variable values in ssis generated biml. managed create event handler writes everytime variable changes value. when log use parameter value set "system.variablevalue". pass parameter (togheter variablename , packagename) storedproc , write in log table. problem (but not always) seems parameter not has value. see new line in db log table means evnt correctly raised , handled seems parameter empty. strangest thing values logged correctly not always, not same variables, not same packages, rather, in quite random fashion.

could problem fact several variables change value @ same time (some contention on db) ? doubt it, because row gets written on db. tried write, value, 'new value = ' + ? is, appending parameter value fixed string. fixed part gets written correctly but.. no value. name of variable changed value written correctly.

any idea due to?

as workaround tried use ready-made logging facility of ssis in case in message column of sysssislog table can read name of variable changed, not new value.

thankx

you use event handler that. go variables page, go variable grid options, check raise event when variable value changes, , there should 1 more option appear variables, raise change event, default false, change true variables need track changes (log). , put logging task event handler

update new line value of parameter has been reset, , value, equal blank or whitespace, still, recognized value change.

if not sure when happened, set breakpoint task , add watch window see how value change or whether value hit blank in middle of process