SQL Server Performance

Expression and Constraint

Discussion in 'SQL Server 2005 Integration Services' started by gujsa01, Feb 22, 2008.

  1. gujsa01 New Member

    Hi,
    I have a Execute SQL Task that outputs a resultset. I would like to check the output variable (which in this case is of the type object) using the "Expression and Constraints" Evaluation option of the Precedence Constraint if it is empty before running the next task.
    Tried "!ISNULL(@ReturnVal)" which returned , "The data type of variable not supported in expression" error.
    Is there a way to evaluate object variable in an expression??
    Appreciate any help.
    Thanks
  2. dineshasanka Moderator

    What is the data type of the variable @ReturnVal

Share This Page