ssis-migration
CommunityMigrate SSIS to Databricks notebooks
Authorlucaslessachaves
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Analyzes SSIS packages and SQL Server stored procedures, then generates Databricks notebooks following the Medallion architecture (Bronze/Silver/Gold) with Unity Catalog for a scalable, auditable migration path.
Core Features & Use Cases
- Analyzes DTSX packages to extract connections, control flow, and data flow components, including variables and precedence constraints.
- Analyzes stored procedures to map patterns (INSERT, MERGE, SCD) and audit logic for Spark-based pipelines.
- Generates Bronze, Silver, and Gold notebooks, plus supporting artifacts (DDL, workflows, and validation queries) and ensures secure credential management.
Quick Start
Provide the SSIS package (dtsx) or stored procedures to begin the migration and the system will generate Bronze, Silver, and Gold notebooks along with supporting artifacts.
Dependency Matrix
Required Modules
lxml
Components
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: ssis-migration Download link: https://github.com/lucaslessachaves/default/archive/main.zip#ssis-migration Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.