Flat File Source issue

I am using a Flat File Source to write data to a table.

The file is not delimited, and uses <crlf> as a end of row marker, it is of the form:

Catalog No(10) Qty(3) Status(3) Date(8)<crlf>

So a typical line is of the form:

1234567890 03HNN20040602<crlf>

However, in some cases, the 3rd and 4th columns are not present, eg

1234567890 01<crlf>

In the Flat file conection manager, as soon as a record is found with the columns missing, it ignores the fact that the <crlf> is there to mark the end of the line, and all gets in a mess.

I would have expected that an end of line marker would take "priority" over column widths, leaving empty colums

Using Ragged Right, rather than fixed width, it looks OK in the columns screen, but is very wrong indeed in the Preview screen.

In both DTS on SQL 2000 and Access using Get External Data from a txt file, and it works as I would have expected. Am I doing something wrong, or am I going to have to write all the data to a table and then split it with some code This seems to be a bit of a step backwards from DTS.

Thanks in Advance!

SteveG