When the SSIS Variable type is String, and you use OLEDB connection for the Execute SQL Task, the datatype of the result of the query should be Nvarchar or Nchar.

The...