1.Set the "EvaluateasExpression" property of the variable as True.
2.Set the "RaiseChangedEvent" property of the variable as True.
3.Create an event handler for the "OnVariableValueChanged" event for the container in which the variable is scoped.
4.Add an execute sql task in event handler to insert the current value of the varibale in a table by writing the Insert statement and passing the variable as parameter.
Replied on Jun 20 2011 8:47AM