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.

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:

But in Data Flow, the UI looks like:

I have a workaround is that we could choose the table with Query in Source operations:
'select * from ' +$TableName

Pipeline parameter:

Data Flow parameter:

It works well.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With