SSIS packages migration to Databricks Workflows

Vetrivel
Databricks Partner

We are doing POC to migrate SSIS packages to Databricks workflows as part of our effort to build the analytics layer, including dimension and fact tables. How can we accelerate or automate the SSIS package migration to Databricks environment?

szymon_dybczak
Esteemed Contributor III

Hi @Vetrivel ,

I think there is no automated solution for this kind of task. You can leverage GenAI to help you automate some things. You can take a look at Databricks entry blog where they're suggesting this approach:

GenAI Assisted ETL Migration — Transforming SSIS Packages to Databricks workflows | by Thomas Zhang ...

View solution in original post

thelogicplus
Contributor II

Hi  Vetrivel,

There are many company  which have accelator , who can help you to migrate ssis to databricks, check with travinto.com.   we are using their accelator with services from travinto and migrated  200+ till today 24-Nov-2024. These guys are awesome and recommended by some of my colleagues.

 

View solution in original post

BlakeHill
New Contributor II

Thank you so much for the solution.