My Execute SQL Task General Tab has a ResultSet of SingleRow, Connection Type OLE DB, Connection of CCXXSDDB010.ietenterprise, SQL SourceType of Direct Input,
and just to test I have a SQL Statement of "SELECT 'rePORTAL_OLD' AS databasename"
Within the Result Set properties I have RESULT NAME set to databasename and VARIABLE NAME set to User::InDatabase
Nothing under the expressions properties window.