DataSource receive parameters from Dataflow

Question

Hi,

I'm having some problems making the DataSource in receive the parameters that comes from the Dataflow that uses the DataSource.

This is my parameters configuration on the DataSource side:

Wich i use this code to get the parameter from Dataflow:

What i want to do with this code: concatenate a folder name with a date structure folder eg.: <entity>/year/month/day/file.csv
but the parameter scr_dia doesn't get the value from Dataflow

From the Dataflow side, i have this parameters:

So at the end my question is: how can i make reference to the variables/parameters from Dataflow?

Answer 1

Hi @Higor Silva Grilo ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

As per my understanding, you are trying to pass parameter/variable values to the dataflow that can be used in connecting to the source. Below is a GIF showing on passing values from pipeline to dataflow and it is related to SQL.

Hope this helps! Please suggest if this is similar that you followed and facing an issue or the requirement is different, we will continue to work with you on this.