File System Items Source object allows reading from multiple files. In a dataflow, this object allows reading rows from multiple source files by providing fullpath as input to the source object changed to transformation. These data rows can be transformed as needed and written to a destination.
The filepath can also be written to the destination if required, as shown in the above screenshot.
If we want to write other fields from the File System Items Source to the destination, that can be done by using a Join object.
We will map fields from the source object along with the file path as the first input to the Join object, and fields from the File System object, with the fullpath as the second input of the join object.
We will use filepath from the source and fullpath from the FileSystem as the Join fields and enable the option sort right and left input in the Join properties.
We can map the fields to the destination object. The destination can then get data from the source files along with the associated data from the File System Item source object such as the file name, extension, last access time etc.
