• 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.