DSXchange

I am trying to read excel sheet in Sequentail file and writing it to DB2.
Am getting all the junk data in the view data(Seq file) and also it is showing less no of records.
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 1, column LF_ID, required column missing
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 2, too many columns in record
TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 3, column LF_ID, required

Thanks
Shivan

The records are of varying columns.

The records are of varying columns.

Can you please elaborate this?

Thanks
Shivan

Sainath.Srinivasan wrote:The records are of varying columns.

You can't use a Sequential File stage to read a spreadsheet unless you've saved it in .csv format first. To read the .xls directly you need to use the ODBC stage instead.

Like Craig said you should convert the excel file to a .csv file and also the no of columns and column length in the sequencial file stage should match the csv file, otherwise you would get the error you mentioned.