How to import varchar(max) into SSIS string variable.
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.