Here’s a list of SSIS-related features:
- Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are in Azure Government cloud.
- When you use SQL Agent of Azure SQL Managed Instance via SSMS, you can configure parameter and connection manager in SSIS agent job step.
- When connecting to Azure SQL DB/Managed Instance, you can connect to it with default as initial db.
- Added a new entry item Try SSIS in Azure Data Factory under “Integration Services Catalogs” node, which can be used to launch the “Integration Runtime Creation Wizard” and create “Azure-SSIS Integration Runtime” quickly.
- Added Create SSIS IR button in “Catalog Creation Wizard”, which can be used to launch the “Integration Runtime Creation Wizard” and create “Azure-SSIS Integration Runtime” quickly.
- ISDeploymentWizard now supports SQL Auth, Azure Active Directory Integrated Auth, and Azure Active Directory Password Auth in command-line mode.
- Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS Integration Runtime.
I’m not able to address or comment on each item. I can cover a few. Click the links above for more information.
Please note I am using SSMS v18 with SQL Server 2017.
Need Help Lifting and Shifting SSIS ?
Please contact Enterprise Data & Analytics to learn more.