SSIS ScriptComponents are not that bad

Many do not recommend using ScriptComponents in SSIS, as they are notoriously difficult to maintain. Which is true, however they are also extremely powerful.
It will be demonstrated that it is easily possible to even broaden the usability of scripts, by being able to iterate over all columns at runtime, without the need to know column names beforehand. So, the same script component could be reused over several SSIS packages to do specific repeating tasks.
Synchronous operations are quite simple to do, asynchronous needs a bit more work and it will be demonstrated to build scripts with BIML, which can also help with maintainability.

Get a guide to mass update SSIS script components Inside into the workings of SSIS programmatic interface.