When you import source objects, the Secure Agent appends a FileName field to the imported source object. The FileName field stores the absolute path of the source file from which the Secure Agent reads the data at run time.

For example, a directory contains a number of files and each file contains multiple records that you want to read. You select the directory as source type in the Microsoft Azure Data Lake Storage Gen2 source advanced properties. When you run the mapping, the Secure Agent reads each record and stores the absolute path of the respective source file in the FileName field.

When you use the FileName field in a source object, the Secure Agent reads file names differently for mappings in advanced mode.

Format type	Syntax	Example
Complex file	abfss://<filesystem_name>@<account name>.<endpoint>/<directory>/<source_file_name>	abfss://adapterqa-source@adlsgen2qa.dfs.core.windows.net/parquet/reader/customer.parquet
Flat file	<directory>/<source_file_name>	csv/customer.csv