The column and row delimiter character, quote character, and escape character must all be different for a source definition. These properties must also be contained in the source or target file code page.

The escape character and delimiters must be valid in the code page of the source or target file.

In a quoted string, use the escape character to escape the quote character. If the escape character does not immediately precede a quote character, the Integration Service reads the escape character as an ordinary character.

Use an escape character to escape the column

delimiter

. However, in a quoted string, you do not need to use an escape character to escape the

delimiter

since the quotes serve this purpose. If the escape character does not immediately precede a delimiter character, the Integration Service reads the escape character as an ordinary character.

When two consecutive quote characters appear within a quoted string, the Integration Service reads them as one quote character. For example, the Integration Service reads the following quoted string as

I’m going tomorrow:

The Integration Service reads a string as a quoted string only if the quote character you select is the first character of the field.

If the field length exceeds the column size defined in the Source Qualifier transformation, the Integration Service truncates the field.

If the row of data exceeds the larger of the line sequential buffer length or the total row size defined in the Source Qualifier transformation, the Integration Service drops the row and writes it to the session log file. To determine the row size defined in the Source Qualifier transformation, add the column precision and the delimiters, and then multiply the total by the maximum bytes per character.