when try to add dynamic file name (linked server) in azure data factory V2 error encountered

1
votes

I am new to the Azure Data factory V2 and blob storage. When try to add the file connection(linked server) in copy data from blob storage dynamically the following error is encountered while trying to map the columns by importing the schema from file

"Failed to convert the value in 'container' property to 'System.String' type. Please make sure the payload structure and value are correct.."

I tried:

used static parameters and assign the static parameters to the linked connection

1
azureazure-blob-storageazure-data-factory-2

1 Answers

1
votes

Please refer to my working steps:

1.Configuration of Azure Blob Storage Source DataSet:

enter image description here

parameters:

enter image description here

2.Configuration of Azure Blob Storage Sink DataSet:

enter image description here

3.Configuration of Copy Activity,you could modify the value of parameters here:

enter image description here

4.Result:

enter image description here