Note that xp_dirtree is an undocumented stored procedure.
To find the newest file added to a folder using SSIS a Script Task might be the simplest way.
Some sample pseudo code
Dim latestFile as System.IO.File
For Each(System.IO.File file in System.IO.Directory.GetFiles(..))
Begin
' if the date of the latestFile is before file, set latest file to file
End
' latestFile isbthe file you want to process
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato