3

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

Improve this question

2 Answers 2

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

That works perfectly and I will certainly accept this answer so thank you. However, my next task would be to figure out how I can do the same thing in the sink. If I was able to do that, then I could have a completely generic data flow that can map from source (pass in table name) to sink (pass in table name).
@Geekn Sorry for reply you for late. We can not set it in Data Follow sink for now. May I know why you unmark it?
1

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.

Improve this answer

1 Comment

Actually I see it now. You just set them in the parameters for the dataflow activity. The work around above works, but doesn't seem necessary now..

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.