Data pipeline: Copy Data, Sql Server connection, how to parameterise the Table name

[msprog]

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 no way to parameterise the TableName for the Source configuration( Sql server) of Copy Data. 

Has anyone done this please? Please suggest.

thanks

[wardy912]

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.DB

 Swap DB for your parameter name

I hope this helps, please give a thumbs up and mark as solved if it does, thanks!