Save File Path to Table

Question

I need to import multiple files. Instead of saving the file name with each record, how do you save the entire file path?

Answer 1

Create a parameter or variable, let's say filePath, to store the entire file path. You can set its value using an expression.

If you're using a parameter, you can use the following expression in the parameter's value field:

@concat(dataset().folderPath, '/', dataset().fileName)

If you're using a variable, you can use the Set Variable activity and set the variable's value with the expression: @concat(dataset().folderPath, '/', dataset().fileName). Here, dataset().folderPath and dataset().fileName are system variables provided by Azure Data Factory that represent the folder path and file name, respectively, of the current file being processed.

Answer 2

Hello @Ariel M,

I have a dynamic folder from where I read daily file from a folder which is created dynamically. I hope this helps with your scenario!

S500USCustomers/@{formatDateTime(utcnow(), 'yyyy-MM-dd')}

Inside the ForEach, I have GetMetaData:

the Source File path has an expression:

@concat('input/S500USCustomers/',formatDateTime(utcnow(), 'yyyy-MM-dd'),'/', item().name)