How to pass variable to data flow

Question

How do you pass a dynamic variable value to a data flow? It's a file name for the source dataset.

Answer 1

Hi PeterP1550

1. inside data flow, create a parameter called filenameparam (click on white space, you will see parameters tab)
2. Click on debug settings, and under parameters, assign a default value '' for file name param we created in step 1
3. from pipeline, click on data flow activity, you will see the parameter you created in step 1. click on the expression option and choose pipeline expression. Then choose the variable that holds filename.
4. go to source in data flow and click on options tab. under the wildcard option, select the data flow param created in step1.

Please refer to this documentation page for more details https://learn.microsoft.com/en-us/azure/data-factory/parameters-data-flow

Also, here is a video that talks about parameterizing file name for source (with only difference being, the file name comes from a foreach item and not variable)

Hope this helps.