ADF lookup - pass where clause parameter not working

Question

Hello
I get invalid column name xyz

note that xyz is a parameter I enter
@markus.bohland@hotmail.de ('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?

Answer 1

Hey,
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}'