Issue Reading from Fixed width file

[meet_deb85]

I have my source data as follows: -

10Pending
20Hold

the width for the fisrt field is 2 and second is 10, I have added space char after the data in the second field to make it 10 characters long.

I have set the Record Length as fixed, and i have defined under the string type option in the extended columns property tab as Field Width=2 and Field Width=10 for respective columns.

But I am still getting the following error : -
Seq_Load_Profile: Unable to initialize the importer.

Seq_Load_Profile: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "Field001".

[ray.wurlod]

Make both data types Char. Char(2) and Char(10). Do not use VarChar.

[meet_deb85]

hi Ray,

I have kept it as Char(2) and Char(10), but still getting the same error

[meet_deb85]

Resolved it by setting Record Delimiter as UNIX NewLine

[Sreenivasulu]

I think you keep 'varchar' with 'fixedwidth' it will work

Regards
Sreeni