ADF lookup - pass where clause parameter not working

arkiboys 9,686 Reputation points
2021-09-08T08:19:42.847+00:00

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?

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
    2021-09-08T08:42:24.097+00:00

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

    130019-image.png

    And you can try the below query:

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

0 additional answers

Sort by: Most helpful