Trace SSIS variables value

Insert Script Task Editor in Control Flow and use Visual Basic language

Insert the below lines between Public Sub Main() and End Sub

TypeVariableName is variable Name


Public Sub Main()
Dim variableList As Variables

Dts.VariableDispenser.LockOneForRead("TypeVariableName", variableList)

MsgBox(variableList("TypeVariableName").Value.ToString())
variableList.Unlock()

Dts.TaskResult = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success

End Sub