'In Azure datafacctory in copy data activity only top 3 parameters of linked services are shown in source settings

In Datafactory I'm using CopyActivity to copy data from SQL database to Azure table storage. I'm filling up the sql connection linked service properties dynamically. So I have declared 4 properties each for server,databese,usename & password . enter image description here

But when I'm using this linked service in the source of CopyActivity only top 3 parameters are showed. Is it a limitation or an error ?

enter image description here

azureazure-data-factoryazure-data-factory-2


Solution 1:[1]

I have tried in my lab environment and noticed that if you have created a source dataset from copy data activity with parameters, initially is showing only 3 parameters under dataset properties.

But if you refresh your dataset in copy data activity it is then showing all the 4 parameters.

Or you can first create your dataset and then add copy data activity to your pipeline and select your source dataset to show all your parameters in Dataset properties.

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 NiharikaMoola-MT

Related Questions