I've just noticed a problem with a DTS package I've designed, and was
wondering if anyone else had had a similar problem.

Basically, I have a data pump task which takes an Excel .csv file and
transfers the data into a SQL table. Each .csv column is mapped to a
column in the destination table. OK so far.

However, I've noticed that if the .csv file happens to have ONLY ONE
ROW of data, and there are any blank fields at the end of that row,
these fields are NOT separated by commas - in effect, they "don't
exist" and the file (if opened in a text editor) simply stops at the
last populated field.

Obviously, the DTS sees this as a csv file with one row of data, and an
incorrect number of fields (i.e. not enough!)

Does anyone have any suggestions? I'm not really able to alter the csv
file as I won't have control over that, and really need a way of
somehow making the DTS "add commas" or something in such a situation.