CODEWITHSUNDEEP
azure-data-factoryazure-mapping-data-flow
K N
K N

Reputation: 343

How to provide LinkedService with a parameter value from Mapping Dataflow?

I am doing a SQL Azure Database as a datasource in a mapping dataflow. The parameter KeyVaultConnectionString should be dynamic. Se picture 1.

My problem is that I am unable to fiugure out how to provide the value from mapping dataflow. I have tried different things like @pipeline.parameters.ConnString but thats just crap.

enter image description here

enter image description here

Thanks.

***** UPDATE (28-09-2022) *****

I forgot to explain that the flow is a Flowlet. The picture below shows the Flowlet that uses a SQL Server as a Source. I choose Inline dataset but I am not able to pass variable from the "outer" mapping data flow to the datasource.

enter image description here

Upvotes: 0

Views: 521

Answers (2)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

When you are in design/debug mode from the data flow designer, parameters will show in the right-panel when you click "Debug Settings" on the top of your designer window.

Upvotes: 0

Saideep Arikontham
Saideep Arikontham

Reputation: 6114

For inline dataset as source in dataflows, the parameter option is not showing as a separate section. I tried to use the following linked service where I am using the linked service parameter to give my blob storage name.

enter image description here

  • Now when I use this in the dataflow source as inline dataset and try to test connection, it fails.

enter image description here

  • However, complete configuring the dataflow with required transformations and use dataflow activity in azure data factory pipeline. Here it shows the parameter to which the necessary value should be passed to linked service.

enter image description here

Upvotes: 0

Related Questions