查找活动查询需要在where子句中使用字段数据值 [英] Lookup Activity Query Needs to Use Field Data Value In Where Clause

问题描述

我正在执行查找活动，其中正在为我的Azure SQL接收器提供SQL查询.查询的where子句需要使用来自源的实际数据(经过一个If活动后).我尝试了几次，但我可以 不成功.请帮忙.

I am having a Lookup Activity in which I am providing an SQL query for my Azure SQL sink. The where clause of the query needs to use the actual data coming from source (after passing through one If activity). I have tried a couple of times but I could not be successful. Please help.

推荐答案

Ray，

您能否提供有关要放入查询中的哪种源数据的更多详细信息?

Could you provide more detail information about what kind of source data you want to put in the query?

基本上，我们使用 

Basically, we use expression like 

select * from @{activity('formerActivity').output.somevalue}

在查询中.

这篇关于查找活动查询需要在where子句中使用字段数据值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！