Allow choosing logical AND or logical OR in activity dependencies
We have activity dependencies today, but they are always logical AND. If we have Activity1 -> Activity 2 -> Activity3 and we want to say if any of these activities fail, run activity 4, it isn't straight forward. In SSIS, we can choose an expression and choose whether we need one or all conditions to be true when there are multiple constraints. We need similar functionality here. It can be achieved with a bit of creativity (repeat the failure activity as the single failure path after each of the original activities use the If Condition to write logic that would denote failure in a previous activity), but it's more convoluted than it needs to be.
We need the logical and/or functionality for dependencies in ADF. This is not just to have a more robust and mature tool but also to cut down on cost for companies that have chosen Azure. A couple of years ago, I converted my company's SSIS packages to ADF v2. Everything worked smoothly but the one big issue my company had was the unexpected cost from ADF. They decided to convert back to SSIS. Lessening the amount activities required will help reduce the cost.