SSIS Variable Expressions

  • Below video will give clear explanation

    [YouTube]https://www.youtube.com/watch?v=ZroIo6LX6ss&t=420s[/YouTube]

  • Carol Adams - Wednesday, April 22, 2009 5:51 AM

    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::InDatabaseNothing 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------------------------------

    This is a validation error, not a runtime error. Notice how the error is 'Error at Transfer Database Task', which presumably uses the variable as one of its parameters.
    Try leaving a default value for your variable and allowing the ExecSQL task to overwrite that value when it executes.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply