Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.

One day I would like to meet these people, but only if I have full immunity from prosecution.