I’m using a Query Transform to map the data from an Excel into a CSV staging file, but there is a column which occasionally includes line feeds in its data and this is causing an error when running the job due to being in the incorrect column for the end of the row.
Is there a function I can use to remove line feeds in xls source Data Services
C:/Users/Administrator/Downloads/filenme1.txt,-1,A row delimiter was seen for row number <160> while processing column number <10> in file <C:/Users/Administrator/Downloads/filename1.txt>. The row elimiter should be seen after <26> columns. Check the file for bad data, or redefine the input schema for the file by editing the file format in the UI