You can use a file list as a source for flat file connections. A file list is a file that contains the names and directories of each source file that you want to use in a mapping. Use a file list to enable a task to read multiple source files for one source object in a mapping.
For example, you might want to use a file list if your organization collects data for multiple locations that you want to process through the same mapping.
You configure a source object such as a Source transformation or Lookup transformation to read the file list. You can also write the source file name to each target row. When you run a mapping that uses a file list, the task reads rows of data from the different source files in the file list.
Use the following rules and guidelines when you create a file list:
Each file in the list must use the user-defined code page that is configured in the connection.
Each file in the list must share the same file properties as configured in the connection.
If you do not specify a path for a file, the task assumes that the file is in the same directory as the file list.
Each path must be local to the Secure Agent.
You can create a file list manually or you can use a command to create the file list.