Incorrect parameter mapping in a dataflow

Question

Hi,

I have faced the problem with using definition of parameter.

In a DataFlow in source stage, I use a storage procedure with parameters as an input.

If I directly put a parameter name in a value, it looks OK (because in expression builder he recognises it as a parameter.

It is different presented in a parameter Value.

When I put parameter name by expression builder, it looks like this:

The problem is that I case of direct putting parameter value, runtime treat it as value, not as a parameter.
Difference in source code is like this:
-"     inputs:['@tabname' -> '$parDMTab','@src' -> ($parExtraSrc2)],",

+"     inputs:['@tabname' -> ($parDMTab),'@src' -> ($parExtraSrc2)],",

For me it looks like an issue.

Answer 1

Hi Gużewski, Jacek ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

As per my understanding you are trying to pass parameter value for stored procedure in mapping dataflow of ADF via dataflow parameter.

Parameters in dataflow can be referenced in data flow expression.

In case if you want to use dataflow parameter , you need to pass it via expression only so that it would be treated as dynamic, if you directly type the value in the textbox , it is treated as static value as a string.

Kindly consider choosing the parameter from the list of available parameters inside of the Expression Builder under the Parameters tab.

To Assign parameter values from a pipeline , select pipeline expression language

Hope it helps. Kindly let us know how it goes. Thankyou