SSIS is a nightmare for source control. Difficult to code review, impossible to merge. I was hoping that Microsoft's next offerring would be capable of source code management of a modern programming language.

Then I read this: https://docs.microsoft.com/en-us/azure/data-factory/continuous-integration-deployment#unsupported-features . Can't Cherry Pick?

We run Release Flow (recommended by Microsoft!) https://docs.microsoft.com/en-us/azure/devops/learn/devops-at-microsoft/release-flow

This allows us to keep merging to a minimum, do hotfixes by applying cherry picks really well for all of our SQL, Powershell etc.

The Hotfix approach that this document suggests is basically GitFlow - I don't really understand why the Release Flow approach wouldn't be supported, by their nature hotfixes tend to be minimal changes - they aren't going to introduce new datasources etc - surely if we have tested in our feature branch, it merges ok into master then we cherry pick that master commit into the release, why wouldn't it work?

If it wouldn't, please reconsider how it could be made to work. It's really important