The most fundamental principle of every engineering practice is Don't Repeat Yourself. This is so ubiquitous that every field has a different name for it:
- DRY/DIE (Engineering)
- Code Reuse (Software design)
- Single Source of Truth (Database development)
- Occam's Razor (Everywhere!)
Yet, there is no way to design reusable components in SSIS. This is the absolute deal-breaker to any software designer who has considered learning SSIS for a project. To us, copying and pasting between every data flow is simply not an option.