When you select

No quotes

in

Text qualifier

and specify the escape character in the flat file schema format properties, extra columns are added while previewing the data.

When you use the FileName port in a complex file target and run a mapping with mapping flow enabled in the native environment, the Data Integration Service does not create the folder structure as expected.

When you refresh the source or target schema at runtime in a dynamic mapping, the values that you specify for the delimiter, text qualifier, and escape character for a flat file are not honored and the default values are used instead. This might lead to unexpected results in the target.

When you import an object from sub directories with names having a space, data preview fails.

When you create a pass-through mapping to read data from a flat file and write data to another flat file target and enable run-time linking,

'#'

is added to the first column name in the target file when you run the mapping first time on the Spark engine. The mapping fails at subsequent runs.

When you run a mapping, in the native environment, to read a flat file that has unicode characters, a space, null values, single quotes, or a value that starts with a dollar sign, the Data Integration Service adds double quotes to the values when writing data to the target.