Not sure whether DTS/SSIS will ignore trailing commas, however, I can think of two ways to remove them from a file :-

1) if the file is not too big, then...