TXT File with fixed length fields

[ray.wurlod]

If you have any VarChar columns change them to Char.

[joycerecacho]

I tried but it didnt work.
And then I tested with only one char field, the same warning happened.
I can't realize what it could be.

Best regards.

[chulett]

Found this in an older post:

In order to get the fixed width file format recognised I have had to go to the Columns tab, right click, choose Edit Row and set a Field Width value for each row (i.e. the Length field despite being set, doesn't appear to be relevant to the field width)

[qt_ky]

Perhaps you have done this already but it's not clear: Double check that there are no VarChar data types set on any column, and also for every column ensure there is a length value.

[joycerecacho]

Yeap, but it is according to your tips.

The file input columns are like:

COD_MDL_ORG ........ char(4) nullable yes
TPO_RPT ................. char(1) nullable yes

Edit Row:
* COD_MDL_ORG
String Type : Field Width = 4
Nullable / Null Field Value = ""

* TPO_RPT
String Type : Field Width = 1
Nullable / Null Field Value = ""

What else should I set?

[chulett]

Not sure it applies much to writing a fixed-width file but wanted to point out that your "Null field Width" values need to match the size of your char field. So:

Code: Select all

Edit Row: 
* COD_MDL_ORG 
String Type : Field Width = 4 
Nullable / Null Field Value = "    " 

* TPO_RPT 
String Type : Field Width = 1 
Nullable / Null Field Value = " "

Four spaces and one space, respectively.

[qt_ky]

Yes, that should "fix" the fixed-length. If not, please post any new and different errors.

[ray.wurlod]

The error message suggests that COL_MDL_ORG is of type VarChar.

[chulett]

And It is not necessary the option 'Record Delimiter = Fixed'.

I assume you mean "Record length = fixed".

[joycerecacho]

Nope .... I didnt set this option.