Consumed more than 100000 bytes looking for record delimiter
Posted: Mon Jun 06, 2011 5:33 pm
I have a similar issue to what is in this post, my metadata is a sequential file and looks like this:
the question mark represent a rare character
y need to past to a dataset with that format
i put the the pipe (|) as a delimiter and do a derivation on a tranformer to clear the rare characters and trim the blankspaces but when i run the job i have this:
Sequential filexx:Consumed more than 100000 bytes looking for record delimiter; aborting
what i can do in this case?
Code: Select all
10030000005|S|23928.00 |
?10030000005|S|23231.04 |
?10030000005|H|9720.00 |
?10030000005|S|19119.36 |
?10030000005|S|17423.28 |
?10030000005|S|147292.08 |
?10030000005|S|9740.00 |
y need to past to a dataset with that format
Code: Select all
IDD(varchar 11) Value(varchar 1) Quantity (Decimal 10)
10030000005 S 23928.00
10030000005 S 23231.04
Sequential filexx:Consumed more than 100000 bytes looking for record delimiter; aborting
what i can do in this case?