Handling Multiple tables Using Data flow dynamically

Question

I tried to use this article in successfully copying data from one table to another using Dataflows in Data factory. Now my scenario is to handle multiple tables in the DB. the above example is for one of the table.

I tried to follow the next article (link) in same series and have created View and For each loop but now wondering how should I put the input in Data Flow activity.

Any ideas or if any one tried the same thing.

Thanks

Answer 1

You will need to use a parameterized dataset that uses a dataset parameter for the name of the table. Then, pass a string parameter from the Foreach activity that contains the table name into the dataset parameter for that data flow activity. This will all be accomplished from the pipeline.