Phil Parkin (7/26/2016)
ChrisM@Work (7/26/2016)
BrainDonor (7/26/2016)
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.
Very well put, Steve.
If you like I'll hold 'em down whilst you perform the surgery.
This is one team I'd like to be a part of.
If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.
If this ever happens (with full immunity) I'd like to join the team.
Tom