ssis-to-dbt-replatform-migration

Validate and deploy SnowConvert SSIS-to-dbt outputs to Snowflake with phase-gated approvals.

Updated Mar 20, 2026
One-click install
npx skills add https://github.com/jamescha-earley/agent-skills --skill ssis-to-dbt-replatform-migration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ssis-to-dbt-replatform-migration
Source: https://github.com/jamescha-earley/agent-skills/tree/main/ssis-to-dbt-replatform-migration
Command: npx skills add https://github.com/jamescha-earley/agent-skills --skill ssis-to-dbt-replatform-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyyaml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill helps teams validate, deploy, and operationalize SnowConvert AI Replatform outputs (SSIS to dbt projects and Snowflake TASKs) into Snowflake, ensuring deployments are safe, traceable, and repeatable.

Core Features & Use Cases

  • Phase-driven workflow with explicit user confirmations for each deployment stage.
  • Scan and inventory of SnowConvert Replatform output, including etl_configuration components and dbt projects.
  • Automated validation checks for placeholder values, missing files, broken references, and hard-coded environment specifics, with guided fixes.
  • Deploy dbt projects and orchestration SQL in dependency order, with rollback-safe options and dry-run previews.
  • Optional operationalization of schedules and monitoring after deployment.

Quick Start

Provide the path to your SnowConvert Replatform Output and follow the prompts to scan, fix, and deploy.

Frequently Asked Questions about ssis-to-dbt-replatform-migration

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

FAQPage Schema
How do I deploy converted SSIS packages to dbt and Snowflake tasks?

To deploy converted SSIS packages to dbt and Snowflake tasks, the Skill validates SnowConvert AI Replatform output, remediates placeholders, and executes phase-gated dbt project deployment alongside TASK and PROCEDURE orchestration SQL in dependency order.

What is the process for migrating SSIS ETL packages to dbt on Snowflake?

Migrating SSIS ETL packages to dbt on Snowflake involves scanning converted Replatform output, validating missing files and broken references, fixing hard-coded environment specifics, and deploying dbt projects with automated table stubs and rollback-safe dry-run previews.

Can I validate SnowConvert Replatform output before deploying to Snowflake?

Yes, you can validate SnowConvert Replatform output before deploying to Snowflake. The Skill enforces pre-deploy validation checks for placeholder values, missing files, broken references, and hard-coded environment specifics with guided fixes.

Does the SSIS to dbt migration workflow require manual approval before deployment?

Yes, the SSIS to dbt migration workflow requires manual approval. It enforces a phase-gated workflow with explicit user confirmations for each deployment stage, ensuring safe, traceable, and repeatable Snowflake operationalization.

What limitations exist when operationalizing Snowflake tasks after SSIS conversion?

When operationalizing Snowflake tasks after SSIS conversion, limitations include resolving placeholder values and broken references before deployment. The workflow handles etl_configuration, dbt projects, and orchestration inventory checks but requires explicit user approval at each phase gate.

Do I need SnowConvert output to use this dbt deployment and validation Skill?

Yes, you need SnowConvert AI Replatform output to use this Skill. It is specifically designed to scan, validate, and deploy projects converting SSIS packages into dbt projects and orchestration SQL stored within the Replatform output directory structure.