• I ran into this same issue with SSIS but after lots of complaining amongst my team, having several experienced SSIS developers "take a shot" at the problem, as well as posting on various forums about the issue...I looked honestly at the source file format and it was true, my CSV file was not consistently formed. SSIS is less tolerant than DTS in this respect. There is also a bug in DTS when processing CSV files in Unicode format so watch out for that.

    Chances are, if DTS can handle it, you still should not use it 🙂

    To be clear, SSIS absolutely can process CSV files, however they must be consistently formed.

    Can you go back to the data supplier and have them provide a consistent format? Can you pre-process the file with something like PowerShell or a .NET console app to bring the file into a consistent state?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato