I am currently working on a project to migrate existing ETL workflows from SSIS to Databricks. I would like to understand how Databricks Genie, Genie Code, or other Databricks AI-assisted capabilities can support this migration.

Can these tools analyze SSIS packages, including .dtsx files, control flows, data flows, transformations, variables, and configurations, and automatically generate equivalent Python, PySpark, or SQL code for Databricks?

For example, is it possible to upload or provide the SSIS package files and have Databricks generate production-ready notebooks or jobs that can be executed with minimal manual intervention?

I am particularly interested in understanding:

• Which parts of an SSIS migration can realistically be automated?
• Can Genie directly interpret .dtsx files, or must the SSIS logic first be exported into another format?
• How well does it handle complex transformations, stored procedures, lookup components, error handling, and package dependencies?
• How much manual validation, optimization, and redesign would still be required?
• Are there any recommended tools, accelerators, or best practices for migrating SSIS workloads to Databricks?

I would appreciate hearing from anyone who has used Databricks AI-assisted tools for an SSIS migration or completed a similar project.