Variables and columnName inside Dynamic Sql

IN SSIS package,

In expression, if you want to show the value of the variable, use double quote “, if you want to put the value under the single quote , use +’” @val +”’

 

FOR Dynamic TSQL

 

if you need to put quotation for the string column in the String concatenation, use four quotations ‘