Extrancting data from Text file

lote11 · Post by **lote11** » Wed May 04, 2011 9:15 am

Hi Datastage Masters,
im trying to get data from a flat file(txt) to a Oracle_OCI. the problem is taht when i run de job i get this error:
[000001]Untitled464..Sequential_File_0.DSLink9: nls_read_fixedwidth() - row 1, column XXX, column unexpectedly ended by EOR

Someone that enlighten me,
thanks

vinothkumar · Post by **vinothkumar** » Wed May 04, 2011 10:11 am

Check the format of the file that you defined in DataStage with the data present in the file. I think its not matching.