Man, SSIS really stunk. You’d end up having to write your own components anyways and had the extra layer of making them look like pricey RAD toolkit bits to satisfy empty suits. And then you’d have to write SSIS packages that wrote SSIS packages to deal with fluid schemas from multiple teams deploying all of the time.
It’s likely not the full story, but there were some crazy export restrictions in the 90s. Apple made a commercial poking at it: https://www.youtube.com/watch?v=XjkoYlpf3EA
They’re very useful for the boilerplate stuff and it’s somewhat rewarding to type out 3-4 letters, hit tab and wind up with half a dozen lines in a bash script or config file.
They tend to get in the way more for complicated tasks, but I have learned to use them as a psychology trick: if I have writer’s block, I just let them pump out something wrong since it’s easier to critique a blob of text than a blank page.
Knock off the childish fucking gatekeeping and go back to reddit. It’s what the wider industry uses.