SQL Server Integration Services
Possible reason could be if your destination table structure or the column data type changed.
I have the same issue and I know proposed solution. Nevertheless if I want to change source xml file I have to use the "Restore Invalid Column References Editor" for all related OLE DB dastinations for tables extracted from xml source. Do somebody know about more flexibile solution
I have not seen a good solution for this problem. Changing the metadata of the source system after the data flow is built requires a manual review of the data flow, and simply removing invalid references in that editor can often lead to changed data being omitted.
I realize that this is not particularly helpful since you are in this situation already, but "Get your metadata right first, not later" is one of the SSIS best practices that I've come up with over the years and finally got around to blogging on: http://bi-polar23.blogspot.com/2007/11/ssis-best-practices-part-2.html