I am thinking of moving our SSIS ETLs to Azure Data Factory. My arguments in favor of such leap are:
Our sources and targets are already in the cloud. ADF is cloud-native so it seems at a good fit.
ADF is a service are therefore we could consume and pay for it on demand. SSIS implies licensing costs and doesn't lend it itself naturally for on-demand consumption (we thought of using DevOps to spin ETL servers on an ad-hoc basis)
Generating ETL code programmatically with SSIS requires very specific skills such as BIML or the DTS API. By moving to ADF I am hoping the combination of JSON and the TSQL and C# in USQL will make the necessary skills more generic.
I am hoping members of the community can share their experiences and thus help me come to a decision.