如何使用在优先约束编辑器的执行 SQL 任务中创建的变量值? [英] How to use a variable value created in an Execute SQL Task in Precedence Constraint Editor?

问题描述

我需要根据 n-multiple 变量值(isnull tr​​ue 或 false)运行 n-multiple Execute SQL Task.该变量是在上一个执行 sql 任务 (CONDITIONAL QUERY) 中的 ssms 脚本中创建的.如何将ssms脚本中的变量值输出到ssis中的条件表达式?

我的两个变量是 @beneficiary 和 @gempar.它们要么存储日期类型值，要么存储空值.

解决方案

除了

I need to run n-multiple Execute SQL Task based on n-multiple variable value (isnull true or false). This variable is created in a ssms script in the previous execute sql task (CONDITIONAL QUERY). How can I output the variable value from the ssms script to the conditional expression in ssis?

my two variables are @beneficiary and @gempar. They either store a date type value or null.

解决方案

In addition to map result set to variable, you may also need to set the execution result of the task to the variable using ExecValueVariable.

Attached is one of my SSIS packages with a variable named HasRecord. Click the Execute SQL Task and set the ExecValueVariable to the desired variable, User::HasRecord.

这篇关于如何使用在优先约束编辑器的执行 SQL 任务中创建的变量值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！