Excel Source --> Data Error DI

dataservices job design
1

Hi,

I want to read rows from the excel sheet . the sheet have data, but in inside DI, show Why ?? And Load Null too.

Other error, Why, I Have decimals in results ? See attachment.

I have created an excel format template to read teh data.
Exists where to specify customs rules in the format template ?

Any help is appreciated. Please do respond asap.

Thanks,
Johnny
DI1.JPG
DI.zip (253.0 KB)

jrodriguez :peru: (BOB member since 2008-01-22)

2

for Excel DI uses ADO Inteface provided by Microsoft, the column data is numeric so its returned as Decimal. The ADO interface automatically detects the datatype of the column based on the data in the cell for first few rows (8 - 10)

its hard to tell from the screen dump what might be causing the issue, can you attch the excel sheet by reproducing the issue with few rows

have to tried by removing all the formatting for that column ?

manoj_d (BOB member since 2009-01-02)

3

Many thanks manoj_d

It’s correct, I had to correct format and it worked well, but it’s a manual job.

See XLS attachment.

Thanks again
RESAGR.zip (211.0 KB)

jrodriguez :peru: (BOB member since 2008-01-22)

4

the columns that are displayed or read as NULL in DI have errors in the excel sheet, the ADO interface will return NULL for such cells in the excel sheet

you will have to fix the error for the cell before loading data to DI, check the source of excel that is adding data to the excel

manoj_d (BOB member since 2009-01-02)