Parameterize Azure SQL Database dataset using Data flow activity

Question

Greetings!!!

Could you please help me on how to parameterize Azure SQL Database dataset in Data flow. I am trying to move data from ADLS Gen 2 blob to an Azure SQL Database in an ADF pipeline using the Data flow activity. In the Dataset I'm able to parameterize it but not able to figure how to specify the parameters in the Data flow.

Thank you

Answer 1

Hi @Raj D ,

Thanks for using Microsoft Q&A forum and posting your query.

You can map the parameter values to your dataset by clicking on the Dataflow activity in your pipeline and under Settings you will see the source parameters populated.

In the above example I'm mapping pipeline parameters to data flow source dataset parameters.

Hope this info helps. Do let us know if you have further query.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators