Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to specify parameters to parameterized source data set in ADF data flow

I have a data flow that has a parameter: TableName. The dataset that is used as a source within the flow is parameterized for a TableName parameter (SQL Server dataset). When selecting this dataset in source setting within the ADF dataflow, it does not allow me to set the TableName parameter as it does when setting the source within a standard CopyActivity.

So how does one use a parameterized dataset in a dataflow if it never allows you to set the parameters?

UPDATE: The settings are actually on the DataFlow activity itself.

enter image description here

like image 278
Geekn Avatar asked Dec 06 '25 14:12

Geekn


1 Answers

As I understand, you mean that you can set the TableName in Copy Active and can't in Data Flow.

In Copy Active, we could set parameter like this: enter image description here

But in Data Flow, the UI looks like: enter image description here

I have a workaround is that we could choose the table with Query in Source operations:

'select * from ' +$TableName

enter image description here

Pipeline parameter:

enter image description here

Data Flow parameter: enter image description here

It works well.

like image 164
Leon Yue Avatar answered Dec 08 '25 07:12

Leon Yue



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!