SSIS Interview Question - How to load most recent file from Folder to Table in SSIS Package

SQL Server Integration Services(SSIS) Interview Question " There are 100 files in a directory. All have the same structure. You need to load the most recent file to table. How will you do that? "
here is the link for code

Complete list of SSIS Interview Questions by Tech Brothers

[krismaly]

I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your volunteership.

[krismaly]

Revisiting

I enjoyed watching this video and I would recommend others to watch your videos. Thanks for educating the community and appreciate your volunteer-ship.

Thanks a bunch

[krismaly]

I enjoyed watching this video and I would recommend others to watch your videos. Thanks for educating the community and appreciate your volunteer-ship.

Thanks a bunch

[balajiabhi]

Hello sir how to get most recent file from folder using script task. Where did you mention that

[Ranjay_Kumar]

Hello Sir,

Many Many Thanks to uploading such kinds of videos, I enjoyed watching this video and learn a lot. One Scenario i have in my mind that if i have two recent file in the same folder with different name and data from the both files need to be inserted in database. So how can we identify both files from the folder.

[JP-tdgt]

Thank you. Solution works for local C: drive path but it doesn't seem to work for a network path i have \\nas...etc. How can this be fixed? I used the message box and the time stamp doesn't match modified date of network drive. But it does match modified date of files in C drive path.