SSIS Variable Expressions

• boyapati.ram100

  SSC Journeyman

  Points: 81

  More actions

  September 26, 2017 at 11:49 pm

  #1961084

  Below video will give clear explanation

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

• Phil Parkin

  SSC Guru

  Points: 247131

  More actions

  September 27, 2017 at 5:52 am

  #1961119

  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.

  ---