ADF and Expression...and parameter....Please help!

Question

Hi @Nasreen Akter @MartinJaffer-MSFT @KranthiPakala-MSFT

This just popped up out of nowhere today:

I have this in my SELECT for a COPY Activity

WHERE (employeeId = @{pipeline().parameters.childparam})

And looking in the Activity Runs I see employeeID = 126855 BUT
It should be employeeID = '126855'

How can I do this? And if I need a SET VARIABLE how do I show it in (employeeID = @{pipeline().childparam nomenclature?

Thanks so much! Sorry but these are all very urgent.

Thanks!
Mike Kiser

Answer 1

Hey @Mike Kiser ,

Use :

WHERE (employeeId = '@{pipeline().parameters.childparam}')

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.