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

user_7596217 0
Viewed 1052

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

azure-data-factory
2 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.

user_105492810

In data flow, you will set the dataset parameter in Debug Settings when designing/debugging your data flow. You can then set the parameter at runtime in the data flow activity settings in the pipeline.

user_73507880
Related