SSIS SFTP Task support Get File List as ADO.net Recordset operation. This option will produce ADO.net data table with following columns. You can loop through ADO.net recordset using ForEachLoop Task. Below is the list of columns and ordinal 0 => Path [DataType=System.String] 1 => Name [DataType=System.String] 2 => Size [DataType=System.Int64] 3 => LastWriteTime [DataType=System.DateTime] 4 => LastAccessTime [DataType=System.DateTime] 5 => CreationTime [DataType=System.DateTime]