I have a very simple job with source and target sequential file stages.
I have a 100 character Unix file with just 1 line. The columns are:
A 10
B 10
C 50
D 30
On the Format tab of the source sequential file stage, I have:
Record Level:
Final Delimiter: None
Record Deliiter: UNIX Newline
Field Defaults:
Delimiter = none
Whenever I run the job, I keep getting the warning:
Import consumed only 80bytes of the record's 101 bytes (no further warnings will be generated from this partition)
Any ideas?
Strange warning from a sequential file load
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
I found the reason and it is definitely a strange one. On the columns tab of the sequential file stage, I rightclicked and added Field Properties. This opens the Edit Column Meta Data window. On this window, the Field Width property for the last column is 10 eventhough on the Columns tab, I specified the length as 30 (this column initially had a length of 10). Apparently, this overrides the length specified. Very strange!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: