Etl Orchestration Ssis 2022

Always Encrypted Support

• Always Encrypted via ADO.NET connection manager with Column Encryption Setting=Enabled
• This capability existed since SSIS 2016 but tooling and documentation improved
• Use ADO.NET (not OLE DB) when connecting to databases with Always Encrypted columns

Azure-SSIS IR

• Continued improvements in Azure Data Factory for hosting SSIS packages
• No SSIS-specific IR changes; improvements were on the ADF platform side

Parquet Support

• Continues from SSIS 2019 via Flexible File components
• Still requires Java Runtime Environment for Parquet and ORC formats
• No additional file format support added

Third-Party Ecosystem

• Third-party tools (KingswaySoft, COZYROC, CData) added managed identity authentication for Azure Key Vault and other Azure services
• Native SSIS support for managed identity remained limited

Why Minimal Changes

Microsoft's strategic direction shifted toward:

• Azure Data Factory for cloud-native data integration
• Microsoft Fabric (then in development) as the next-generation unified analytics platform
• SSIS 2022 maintained compatibility with the new SQL Server version without significant SSIS investment

Migration Notes

From SSIS 2019

• No breaking changes from 2019 to 2022
• Existing packages deploy and run without modification
• Update SSIS Projects extension for VS 2022 if upgrading development tooling
• No new features to leverage -- migration is purely for SQL Server 2022 compatibility

To SSIS 2025

• Plan for significant deprecations and removals in 2025:
  • 32-bit execution mode deprecated
  • Legacy SSIS Service / Package Store deprecated
  • Attunity CDC components removed
  • Microsoft Connector for Oracle removed
  • Hadoop tasks removed
• If using any of the above, begin planning alternatives before upgrading to 2025
• Review Microsoft.SqlServer.Management.IntegrationServices assembly usage -- breaking dependency change in 2025