Populate varchar(max) or nvarchar(max) to SSIS string variable

How to import varchar(max) into SSIS string variable.

Database table

SSIS Varaibles

SSIS query result set object

The foreach loop has to have something in it otherwise the variables don’t get populated.

Execute SQL Task set up. There is only one record returned from the query. Make sure the the SQLStatement handles NULLs via ISNULL(xxx,'') or COALESCE(xxx,'')

Foreach loop setup.