用于case条件的SSIS派生列不显示所需的确切结果
用于case条件的SSIS派生列不显示所需的确切结果
提问于 2018-05-30 08:41:04
I是此case条件表达式作为派生列，结果I不是预期的
(DT_STR,255,1252)((Step1_Emc_stg_Heading >= "315" && Step1_Emc_stg_Heading <= "45") ? "Northbound"
: (Step1_Emc_stg_Heading >= "46" && Step1_Emc_stg_Heading <= "135") ? "Eastbound"
: (Step1_Emc_stg_Heading >= "136" && Step1_Emc_stg_Heading <= "225") ? "Southbound"
: (Step1_Emc_stg_Heading >= "226" && Step1_Emc_stg_Heading <= "314") ? "Westbound" : "Nobound")回答 1
Stack Overflow用户
回答已采纳
发布于 2018-05-30 08:49:07
我认为问题出在第一种情况。
Step1_Emc_stg_Heading >= "315" && Step1_Emc_stg_Heading <= "45"您必须将45替换为大于315的数字，或者必须使用逻辑或||或逻辑与&&
Step1_Emc_stg_Heading >= "315" || Step1_Emc_stg_Heading <= "45"更新1
尝试以下表达式(使用数字而不是字符串，并重新排序条件)：
(DT_STR,255,1252)((DT_I4)Step1_Emc_stg_Heading <= 45 ? "Northbound"
: (DT_I4)Step1_Emc_stg_Heading <= 135 ? "Eastbound"
: (DT_I4)Step1_Emc_stg_Heading <= 225 ? "Southbound"
: (DT_I4)Step1_Emc_stg_Heading <= 314 ? "Westbound"
: (DT_I4)Step1_Emc_stg_Heading >= 315 ? "Northbound" : "Nobound")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50594855
复制相关文章
相似问题