This article explains how to set up high availability for Microsoft SQL Server Integration Services (SSIS) Scale Out deployment on Amazon EC2, presenting two architectural approaches.

• SSIS Scale Out enables horizontal scaling of SSIS packages across multiple Worker nodes
• Option 1: Use SQL Server Failover Cluster Instance (FCI) with Amazon FSx shared storage
• Option 2: Use SQL Server Always On availability group for SSIS high availability
• Both options require SSISDB catalog database and SSIS Master Scale Out service configuration
• FCI provides instance-level failover; Always On provides database-level replication
• SQL Server 2022 contained availability groups simplify object management across nodes
• Prerequisites include VPC with multiple AZs, Active Directory, and Windows Failover Cluster

Both methods ensure SSIS packages continue running without interruption during node failures, maintaining mission-critical workload availability on AWS.