I have a comma delimited text file that should contain 10 columns of
information.
10 rows of data exist.
Row 2 is missing the last 3 columns of information.

Visual FoxPro(VFP) scenario:
===================
I have a staging table with 10 fields and all data types are set to a
character.
When I load the text file, all 10 rows are loaded.
Row 2 is loaded into the staging table with fields 8,9,10 having no content.


DTS scenario:
==============
I have a staging table with 10 fields and all data types are set to a
character.
When I attempt to set up the DTS package, it errors out with message:

"invalid delimited data: text qualifier mus be followed by a column
delimiter (except the last column)"

It is because of row 2.
How do I set DTS to accept the row as is and load the content with whatever
information is available.
I'm sure MS SQL Server's DTS is just as sophisticated as VFP, I just do not
know how to adjust it's settings.

Has anyone figured this out.
Thanks in advance.