Insightful, David, thank you for that input. I have never used SSIS, so can't respond to that. I've written some SSRS reports. I think that they would work in a VCS, as simple check ins/outs (commits) from either the command line or something like SourceTree. I have never seen SSAS, so I can't say.
The adoption of DevOps or Agile is a struggle. One I've seen tried, and failed, here over the last 5 years. In the past some colleagues said they'd try DevOps/Agile, then didn't, then declared DevOps/Agile a failure. So, back to doing things as they've always done before, "because DevOps/Agile doesn't work".
You're brought up an important point about Microsoft. For a company that says they're trying to get everyone to be better at producing solutions, to make it difficult or manual to extract code from SSIS/AS/RS/MS-Access is counter-intuitive. Microsoft, all I can say is, "Huh?"
I live in the US. I've never heard of King Canute. I had to look him up. WOW, what an interesting fellow! King of England, Denmark, AND Norway all at the same time!! It was a long time ago, but still, that must have been hard!
Vis-a-vis MS Access being able to export various objects as frm, bas, etc., maybe it does/can. I don't know, I confess I stay away from MS Access. I work at one of those places where, if you show any attitude to do something, then that is all you'll ever do, for the rest of your career, with them. If it were a one-and-done thing, then I wouldn't mind. But management here tends to think that people can only do one thing. Maybe two things, if they're exceptional. Access isn't anything I want to work in or branded with the, "he's the MS Access guy, take all Access issues to him all the time, every day, forever".
Kindest Regards, Rod Connect with me on LinkedIn.