PLEASE IGNORE THIS POST. I made a mistake here by loading the wrong file. Loading a column with mixed values IS working fine in SSIS for this Flat File.