Consider using a Script task and sorting the files using methods from LINQ as per article https://www.sqlshack.com/using-ssis-foreach-loop-containers-process-files-date-order/

quite an informative article, thanks Orlando.

pleasure

Hi rajarao.m,

when you trying to automate your package what error do you receive?

Are you using SSDT or BIDS?

Is the ".... identifying the files with some location_id ...." done via one...