It is defined on the left side of the screen as a "Package" variable.

I have an "Execute Sql Task" that populates the variable.

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.

When I do set a VALUE on the left window for the variable and disable the EXECUTE SQL TASK, the stream runs.

WHen I clear out the VALUE on the variable and enable the EXECUTE SQL TASK, before it even gets to the 2nd step which is to popup a msgbox with the database name, it aborts with the following message:

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Transfer Database Task [Transfer Database Task]: A source database must be specified.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

BUTTONS:

OK

------------------------------