Control files are simple text files based on which you can create flat file data objects. You can also use control files to update columns at run time for a Read transformation based on a flat file data object.
When the Data Integration Service generates columns at run time, it uses the decimal and thousands separators specified in the flat file data object properties. You must specify only the name of the column in the control file if the column exists in the flat file data object.
When you specify the source type as indirect in the run-time properties in the Advanced view of the flat file source, you can generate column names at run time with the control file.
You can create a control file for a delimited or for a fixed-width flat file.
You can parameterize the control file name and the control file directory in the run-time properties of the flat file data object.
The Data Integration Service processes a control file based on the column metadata that you specify in the control file and the input data.
When you generate column names from a control file at run time and the source data object contains the file name column, the Data Integration Service logs a validation error with the duplicate file names.