This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 32%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi, I have a folder structure in ADLS Gen2 in container source that goes as below:
/table1/2021/01/20/file1.parquet
/table1/2021/02/20/file2.parquet
/table1/2022/01/10/file3.parquet
/table1/2022/01/12/file4.parquet
/table2/2021/01/12/file5.parquet
.
.
.
.
Like wise I have multiple tables..
I want to copy the content of latest file as per current datetime to the Azure SQL Database, How this can be achived, we are looking for only copying the latest file to azuresqldatabase.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Hi @Anmol Ganju , Please go through below posts, it addresses your ask. Thanks
https://stackoverflow.com/questions/70667287/how-to-load-only-newly-added-file-in-azure-sql-db
@Samy Abdul this does not address what I require.
Hi @Anmol Ganju ,
Thank you for posting query in Microsoft Q&A Platform.
You can use GetMetaData activity to get Last Modified Date Time vale of file. So you should consider using it for all your files and then try to compare each other then finally filter our latest file to copy.
Similar kind of logic implemented in below video. Kindly check that to get an idea of doing it.
https://www.youtube.com/watch?v=QHeG36oqkPQ
Hope this will help. Please let me know if any concerns.
---------------------
Please consider hitting Accept Answer button. Accepted answers helps community as well.
@ShaikMaheer-MSFT I understand the process if we need to fetch the latest file from a folder, but here I have multiple date folders for Table1, how should I go about looping thorugh each folder and scanning for the latest file or either compare it from the current date and then identifying which is the latest? Does the process explained can get the child item from a file path /table1/2021/01/20/, even though if I fetch /table1 path to it only?
If I understand you correctly, in that case, have a metadata table or file name encompassing with all the folder names ,and use lookup
activity to read through the metadata file or table , use Foreach activity to pass through the iteration of files to GetMetaData activity and compare and
filter as suggested by @ShaikMaheer-MSFT and earlier links posted. Thanks
Thank you @Samy Abdul for helping here. @Anmol Ganju I hope this is helpful. Please let us know if any further queries.
-----------
Please consider hitting Accept Answer. Accepted answers helps community as well.
Hi @Anmol Ganju ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
@Samy Abdul thanks for this it helps