Reading a fixed widtjh file

[vimali balakrishnan]

I am trying to read from a fixed width file, The file has fixed length record with 500 fields. I am reading only 50 fields out of it by giving the appropriate start positions. The record length is 3300 characters.

I'm reading all fields as Char. When i execute the job, it gives me the following warning message,

Src_ACPSExtract,0: Import consumed only 58bytes of the
record's 3300 bytes (no further warnings will be generated
from this partition)

Src_ACPSExtract,0: Import
warning at record 0.

Could you please some solution which could resolve this?

Thanks

[GJ_Stage]

Could you please check this file length is 3300.

[chulett]

AFAIK, you need to 'read' all columns, even the ones you don't 'need'. And make sure their 'Display' size is correct in the stage as that is what drives how many bytes it reads per record.

[ray.wurlod]

You do have to read all fields, but there is a useful property called "Drop On Import" that you can use to prevent needing to process unwanted fields in your job design.