Koen Verbeeck actually gets an article’s length out of this:
There’s a new version of SQL Server released and we’re mainly an on-premises SQL Server shop. We’ve been using Integration Services (SSIS) for years now for all our ETL and data integration needs. With Microsoft’s focus on cloud (Azure and Fabric), does it make sense to upgrade our SSIS packages? Are there any new features?
Click through for the answer, though “stuff that’s gone away” or “stuff that you have to change because of drivers” make up almost 100% of this.