Thanks for the URL... good one.

My example still doesn't work.

I declared user variable as GetName String

and contactName in the table is varchar and selecting only top 1 values which is signle value.

I can see the correct values from the select statement in the watch window when I debug. But still get the Error

"The type of the value being assigned to variable "User::GetName" differs from the current variable type"

Execute SQL Task: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.