April 13, 2010 at 3:54 am
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.
April 13, 2010 at 4:45 am
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