I am not familiar with how this works in SSIS, but I have done a lot of work cleaning up data from text files and other hacked/dubious file source, and...