SSIS

SQL Server Integration Services

On Premises, part of SQL Server
Mature technology (20+ years), but has:
- Less cloud connectors
- Limited scalability
Data Factory: first choice on new projects ADF can also run SSIS packages

References