Skip to main content

Data Factory

New

Force Dataflow Gen2 to use existing connections

Vote (1) Share
Dilshan Sivanesan's profile image

Dilshan Sivanesan on 21 Nov 2024 10:46:10

We are using a VNET Gateways to connect to a SQL source.

We have a Test and Prod connections.

If in the dataflow we use parameters in the form of a list e.g. par_Server and Par_Database, the flow doesn not use the existing connections. Instead it keeps creating new connections everytime you choose a different value from the drop down