Working with files in SQL/SSIS can be way different experience than expectation.
Here is quick way to get file createdate (not the last modified date) from command prompt using powershell script.
PS: This is not possible in original Linux system as createdate (or birthtime) not stored as per POSIX standard. But current ext4 or BTRFS does have started supporting it
Below PS script can be used to get the file createdate and export all the results in csv directly
get-childitem *.* | select Name,CreationTime | Export-Csv 'scan.csv' -notype
The below command from prompt can be used to execute the PS file
powershell -command .\createdate.ps1
Let Me know if any better way