question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered ewinkiser commented

Hey @ewinkiser,

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @NandanHegde-7720 !!

II'll test it today....

Mike Kiser

0 Votes 0 ·