SSIS in SSMS Version 18

 

Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features!

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 ?

Enterprise Data & Analytics specializes in lifting and shifting SSIS from on-premises to Azure.

Please contact Enterprise Data & Analytics to learn more.