Error in Parsing a Flat File

[system]

Hi,

I am trying to parse a Flat file but getting the following error “Parsing Error” i am confused please help.

The File Structure is given in attachment as well as the field structure and the schema defenation.

Please take a look and let me know if i am missing something.

Thanks
Shaazy

[arulchristhuraj_alphonse]

Can you try once with new flatfile test data and make sure you are not giving more than one new line or space while creating flatfile test data.

[system]

@arulchristhuraj;69626

Can you try once with new flatfile test data and make sure you are not giving more than one new line or space while creating flatfile test data.

@shashank7383

The flat file i have is like this

@& DULL 2009/12 VMS 0121221312213321 FF 5120 TXT Value 2009/09 GG 0211 29/08/09 &&

Where DULL identifies the 1st header segment
FF identifies the second record segment
GG identifies the trailer segment.

Please can you suggest how shall i write the schema about this as there is no delimter nor the record length is fixed.

A details of the step i need to follow

[mangatrai]

create a schema with no record identifier…
Create a flat file dictionary with no record identifier and use it in schema…

You can find the flat file schema guide in documentation folder under integration server folder.

[mangatrai]

PDf name is Flat_File_Schema_Developers_Guide.pdf and it will be inside “_documentation\Developer\Guides” may differ on your IS.

[saisha36]

You can use this attachment & see, whether the flat file gets parsed.
Just a try.
sample1.txt (60 Bytes)