Flat File Conn Mgr Column Limit??

Hi,

I have a flat file with hundreds of columns.

I set up a flat file conn mgr with the following settings:

format: delimited
text qualifier: "
header row delimiter: {LF}
row delimiter: {CR}{LF}
column delimiter: comma

Now, here's the problem. In the preview screen, it shows only up to column 518 correctly. In column 519, it shows the remaining hundreds of columns all glommed together as one big string, like: "data", 123, 10/17/2007, "more data", etc

Anyways, I am wondering what to do about this?

When I attempt to run the data flow I get this error:
[Flat File Source [1]] Error: The column delimiter for column "Column 519" was not found.


However, the good news is that I only need the first 9 columns of the file. Some preprocessing in order, maybe?

Thanks!