Troubleshooting a mapping task

Unable to read flat files that have multiple new line characters or carriage returns.

When flat files contain multiple new line characters or carriage returns, Data Integration is unable to read the files accurately.

To resolve this issue, set the MatchQuotesPastEndOfLine property in the mapping task:

1. 1On the Runtime Options page in the mapping task properties, navigate to the Advanced Session Properties section.
2. 2From the Session Property Name list, select Custom Properties, and set the Session Property Value to MatchQuotesPastEndOfLine=Yes.

Note: The MatchQuotesPastEndOfLine property works only with flat files that use ASCII-based code page. Ensure the file uses an ASCII-based codepage.