I've just encountered this bug too.
What caused it was I edited a package by deleting the Excel source and replaced it with a .rpt flat file source... then all hell broke loose 😀
The only way I managed to fix it (after an hour or so of browsing between the source and target's trees and messing with the codepages) was to delete my Derived Column and OLE DB Destination.
I'm about to press run, wish me luck.
Michael Gilchrist
Database Specialist
There are 10 types of people in the world, those who understand binary and those that don't. 😀