Someone searched my site for this…here’s the answer
String literals are supported in SSIS expressions. You can find those here. So the question was, how can I put a quotation mark in my literal string in an SSIS expression? The answer is to use \” in your expression. A quick example:
Lee
-----------------------
“Please. Have mercy. I've been wearing the same underwear since Tuesday”
81feea20-80d6-42c0-ad15-a3299c61d0eb|0|.0