Exporting fixed length file

  • Hi

    I am exporting a fixed length file from a sql table to .txt file.

    I have sent the type as Ragged right but when I go to the editor screen and the previw screen it gives the message "The last row in the sampled data is incomplete. The column or row delimiter maybe missing........".

    When I hit ok and looks at the data it clearly doesn't look right as there square symbols on later columns.

    I checked the columns and the last column has a column delimiter of CR LF and output width of 4 (which is correct the width)

    when the task is executed the final file looks ok until I see that the last column value has shifted right along the file to a position it should not be in.

    Any ideas on what I need to do to export this file correctly?

    thanks in advance.

  • i have sorted this - it was exporting to an old .txt file format, hence not working.

    more care, less haste!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply