SSIS is a piece of shit. As well as Visual Studio.
SSIS job running on sql server bombs on vs_needsnewmetadata. I go to fix the issue by refreshing the db source and target tasks to re-read metadata from the db servers. While "refreshing" the metadata, IT policy requires reboot of computer, and triggers autoupdate of visual studio, and hoses my IDE. spend an hour re-installing VS and SSDT, bc the newest version of VS can't deploy to sql server thru the IDE. I'd rather code in Eclipse/Intellij ARGHHHHHHHH