
Amazon RDS Custom for SQL Server now enables you to deploy Microsoft SQL Server Integration Services (SSIS) packages directly on the database instance, eliminating the need for separate EC2 resources and reducing infrastructure costs.


<div><p>This article explains how to migrate Microsoft SQL Server SSIS packages to Amazon RDS Custom for SQL Server, enabling cost savings by eliminating separate EC2 instances.</p><ul><li>SSIS packages can run directly on RDS Custom for SQL Server instances</li><li>Requires SQL Server 2019 Standard/Enterprise edition or above</li><li>Instance must be joined to AWS Directory Service for Windows Authentication</li><li>CLR integration must be enabled on SQL Server</li><li>Deploy packages via SQL Server Management Studio using .ispac files from S3</li><li>Five-step process: create RDS instance, configure SSIS, upload to S3, import to EC2, deploy to RDS</li><li>Eliminates need for separate SSIS hosting on EC2 or on-premises servers</li></ul><p>This solution provides flexibility and OS-level control while reducing infrastructure costs compared to traditional SSIS deployments.</p></div>


Related articles