Expression and Constraint | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Expression and Constraint

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

What is the data type of the variable @ReturnVal

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |