topic Re: SSIS packages migration to Databricks Workflows in Data Engineering

SSIS packages migration to Databricks Workflows

Vetrivel — Wed, 06 Nov 2024 04:10:27 GMT

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?

Re: SSIS packages migration to Databricks Workflows

szymon_dybczak — Wed, 06 Nov 2024 12:39:21 GMT

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 | DBSQL SME Engineering | Medium

Re: SSIS packages migration to Databricks Workflows

thelogicplus — Sun, 24 Nov 2024 17:40:57 GMT

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.

Re: SSIS packages migration to Databricks Workflows

BlakeHill — Wed, 11 Dec 2024 05:43:09 GMT

Thank you so much for the solution.