Skip to Content
0
Former Member
Nov 18, 2013 at 09:56 AM

excel source question

25 Views

Hi,

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

thanks