When you configure a session to write to file targets, you must correctly configure the flat file target definitions and the relational target definitions. The Integration Service loads data to flat files based on the following criteria:
Write to fixed-width flat files from relational target definitions.
The Integration Service adds spaces to target columns based on transformation datatype.
Write to fixed-width flat files from flat file target definitions.
You must configure the precision and field width for flat file target definitions to accommodate the total length of the target field.
Generate flat file targets by transaction.
You can configure the file target to generate a separate output file for each transaction.
Write empty fields for unconnected ports in fixed-width file definitions.
You can configure the mapping so that the Integration Service writes empty fields for unconnected ports in a fixed-width flat file target definition.
Write multibyte data to fixed-width files.
You must configure the precision of string columns to accommodate character data. When writing shift-sensitive data to a fixed-width flat file target, the Integration Service adds shift characters and spaces to meet file requirements.
Null characters in fixed-width files.
The Integration Service writes repeating or non-repeating null characters to fixed-width target file columns differently depending on whether the characters are single-byte or multibyte.
You can write ASCII or Unicode data to a flat file target.
Write metadata to flat file targets.
You can configure the Integration Service to write the column header information when you write to flat file targets.