Save Azure blob storage filename to Sql table - Azure Data Factory

Question

I have a sales-2016-01.txt file which I upload once monthly to the Azure blob storage. I want to process the sales-2016-01.txt file and save them to sql table. In addition to this I want to store the name of the file against each record in a separate column say ImportFileName. This is to track the record, from which file it was imported.

The filename will be dynamic based on the year and month.

I am using Azure Data Warehouse for storing the data.

Answer 1

It is an old question, but just for the record, in DF v2 in Copy Data activity, it is possible to add a new column to the source with value $$FILEPATH, and then each record will have a name of the input file.