capture file name as a variable
ADF should provide the ability to capture Input File Name and other file related parameters as a variable and pass it as input to other activities like Stored Procedure Activity, custom .NET activity etc. Currently on successful completion of ADF, I would like to store the filename in my on premise (or Azure) SQL DB. Today it is not possible with ADF SP Activity to pass the filename as input parameter.
On top of that it would be great to capture last modified date