Working with Multibyte Data in Fixed-Width Targets
Working with Multibyte Data in Fixed-Width Targets
To load multibyte data into a fixed-width flat file target, configure the precision to accommodate the multibyte data. Fixed-width files are byte-oriented, not character-oriented. When you configure the precision for a fixed-width target, you need to consider the number of bytes you load into the target, rather than the number of characters. The Integration Service writes the row to the reject file if the precision is not large enough to accommodate the multibyte data. When the Integration Service writes the row to the reject file, it writes a message in the session log.
Delimited files are character-oriented, and you do not need to allow for additional precision for multibyte data.