etl-assessment

Extract structure, issues, and complexity metrics from SSIS DTSX packages.

1|1|Updated Apr 15, 2026

Search Tags:#workflow #migration #assessment #snowflake #ssis #dtsx

Ready to run

npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill etl-assessment

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: etl-assessment
Source: https://github.com/Snowflake-Labs/cortex-code-migrations/tree/main/plugin/skills/migration/assessment/etl-assessment
Command: npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill etl-assessment

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires hatchling, xml.etree, json, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps data engineers and architects analyze legacy SSIS packages to prepare for migration to Snowflake by providing detailed structural and complexity insights.

Core Features & Use Cases

Package Analysis: Extracts control flow, data flow, and component details from SSIS DTSX files.
Dependency & Issue Tracking: Attaches issues, issues severity, and effort estimations for each component.
Visual DAGs: Generates interactive diagrams for control and data flow processes.
Use Case: Prepare a comprehensive migration plan by evaluating package complexity, identifying external connections, and planning incremental steps for a full SSIS to Snowflake transition.

Quick Start

Use the etl assessment skill to analyze your collection of SSIS packages in the specified directory and produce a migration readiness report.

Frequently Asked Questions about etl-assessment

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I assess SSIS packages for Snowflake migration readiness?▼

To assess SSIS packages for Snowflake migration, you parse DTSX files to extract control flow, data flow, and component details. This process evaluates package complexity and identifies external connections to build a comprehensive transition roadmap.

What is the best way to track dependencies and issues in SSIS DTSX files?▼

Tracking dependencies and issues in SSIS DTSX files requires parsing package structures to attach issues, severity levels, and effort estimations for each component. This provides detailed structural insights for migration planning.

Do I need Python to automate SSIS package evaluation for Snowflake?▼

Yes, you need Python along with DevOps pipelines and DTSX parsing libraries to automate SSIS package evaluation. These dependencies are required to extract structure, issues, and complexity metrics for migration analysis.

Can I generate visual diagrams of SSIS control and data flow processes?▼

Yes, you can generate visual DAGs for SSIS control and data flow processes. The assessment extracts structural details from DTSX files to produce interactive diagrams that help visualize data pipelines.

Does the SSIS to Snowflake migration analysis provide effort estimations?▼

Yes, SSIS to Snowflake migration analysis provides effort estimations. It evaluates package complexity and attaches severity levels and effort metrics to individual components to help project managers prepare migration roadmaps.

When do I need to analyze SSIS package complexity for a migration roadmap?▼

You need to analyze SSIS package complexity when preparing a comprehensive migration plan to Snowflake. Evaluating package structure and identifying external connections allows data teams to plan incremental steps for a full transition.