ADF lookup - pass where clause parameter not working

arkiboys 9,686 Reputation points

I get invalid column name xyz

note that xyz is a parameter I enter ('select * from eol.LoadTables where SourceSystem = ', pipeline().parameters.pSourceSystem)

When I run the following sql in sql server, I do get rows back
select * from eol.LoadTables where SourceSystem = 'xyz'

Note that if I use the following dynamic content, then the lookup works fine
select * from eol.LoadTables where SourceSystem = 'xyz'

It's just that I am trying to figure out how to pass the 'xyz'

Any thoughts please?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,151 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 31,351 Reputation points MVP

    Can you please provide the image for the input value of the lookup activity:


    And you can try the below query:

    select * from eol.LoadTables where SourceSystem = '@{pipeline().parameters.ParameterNm}'  

0 additional answers

Sort by: Most helpful