Best Way to Migrate ETL (SSIS) to ELT (SQL Script)

One of my client is planning to migrate from on prem to Snowflake Datawarehouse.

Existing solution is build on SSIS. What is the best way to approach this migration