Forum Discussion
Solved
Data pipeline: Copy Data, Sql Server connection, how to parameterise the Table name
Hello, we are testing a Fabric data pipeline with a sql server connection. we use a Copy data task. We want to copy a set of tables from the sql db to a target lakehouse. I notice that there is ...
Hi msprog
Use a 'For Each' task in the pipeline.
Add an array parameter in the following format:
["Table1","Table2","Table3"]On the 'for each' settings add the following item
@pipeline().parameters.DBSwap DB for your parameter name
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi msprog , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.