2130750 - Error: "A row delimiter was seen for row number <> while processing column number <> in file ..." when you run a job that uses Flat File in SAP Data Services

A job that uses Flat File as a source may fail with the following message in SAP Data Services:

A row delimiter was seen for row number <> while processing column number <> in file <C:/dsdata/<filename>.csv>. The row delimiter should be seen after <> columns. Check the file for bad data, or redefine the input schema for the file by editing the file format in the UI.

SAP Data Services 14.x

BODS, BODI, Flat File, row delimiter, CSV, txt file , KBA , EIM-DS-EXE , Job Execution , How To