Discovery phase
In the discovery phase, you create a list of the SSIS packages that you want to migrate to AWS. Different development teams follow different styles, standards, and patterns for developing ETL jobs. We recommend that you review your organization's existing documents to understand these patterns. However, the documentation is often incomplete. You can automate the extraction of important information from the ETL scripts. This saves manual effort and time, reduces human errors, and standardizes the migration approach. Here are some of the important details you'll want to extract:
Total number of control flow tasks
Details of control flow tasks
Total number of data flow tasks
Data flow transformations used
Event handlers
Connection managers
Use this information to understand the ETL patterns used at your organization, to evaluate their complexity, and to identify the appropriate AWS service to migrate this information to.
Migrating these ETL details from SSIS forms the bulk of the migration effort. However, additional properties can provide insights into design and architectural decisions. Some of these SSIS properties are:
Check points
, which are used in SSIS to restart jobs from points of failure Propagate variables
, which help an SSIS package succeed in specific use cases, even when there is an error Transaction isolation levels
, which control the quality of data being read from databases Logging
, to understand the types of logs being captured by the current design and their storage locations
The outcome of the discovery phase can be an inventory, as the following table shows.
This inventory might include the following information:
Package: Name of the SSIS package to migrate
Flow: Control flow
or data flow Task: Name of the control flow task or data flow component
Count: Number of times a task was used in the SSIS package
