Amazon Web Services (AWS) provides services for developing and running extract, transform, and load (ETL) or extract, load, and transform (ELT) jobs and big data workloads. Microsoft SQL Server Integration Services (SSIS) is an on-premises ETL tool that has a graphical interface for building ETL jobs. Depending on the target state architecture, you can use the AWS Glue graphical interface or the Apache Spark framework with Python libraries to build ETL jobs in the AWS Cloud.

This guide describes the steps for migrating SSIS ETL/ELT jobs from on premises to AWS. It discusses migration phases, best practices, and recommendations to reduce the migration effort and improve the experience. The information is applicable to any target AWS architecture.

The guide is for program or project managers, product owners, solution architects, and developers who are:

• Migrating from SSIS to AWS for various reasons, such as modernization or cost savings.

• Primarily using AWS services for ETL and big data workloads.

• Looking for a cloud-based solution to take advantage of a serverless model and flexible pricing.

https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-ssis-etl/welcome.html