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 · Accepted solution]

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!

[v-hashadapu]

Hi @msprog , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[v-hashadapu]

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.

[v-hashadapu]

Hi @msprog , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.