SSIS to Fabric

SSIS to Microsoft Fabric migration

The short answer

Novuz converts SSIS packages, SQL Server stored procedures and SQL Agent schedules into Fabric pipelines, notebooks and warehouse objects with fixed rules. Every object ships with a reconciliation report, and the software runs inside your own Azure tenant.

Take the logic debt scorecard

Risks

What breaks in a SSIS migration

These are the five problems we see most often in SSIS estates.

  • Script Tasks and Script Components hold C# or VB.NET logic that has no direct Fabric equivalent.
  • Package configurations, parameters and environment variables are spread across files, the catalog and SQL Agent jobs.
  • Data flow transforms such as Lookup, Slowly Changing Dimension and Merge Join behave differently when rebuilt as Spark or T-SQL.
  • Precedence constraints and event handlers carry error-handling logic that is easy to lose.
  • Stored procedures called from Execute SQL tasks use T-SQL features that the Fabric warehouse does not support in the same way.

Coverage

What Novuz converts

Final coverage is confirmed during the assessment.

SSIS / SQL Server objectFabric target
Control flow and precedence constraintsData Factory pipeline activities and dependencies
Data flow tasksSpark notebooks or Dataflow Gen2
Execute SQL tasksWarehouse stored procedures or notebook cells
Script Tasks / ComponentsNotebook code, flagged for resolver review
Stored procedures and functionsFabric warehouse T-SQL or PySpark
Tables and viewsLakehouse Delta tables and warehouse views
Parameters and configurationsPipeline parameters and variable libraries
SQL Agent jobs and schedulesPipeline schedules and triggers

Worked example

What a typical estate looks like

An illustrative SSIS estate at a regional utility. These figures are an example, not a customer result.

  • 1,200 SSIS packages, of which 140 contain Script Tasks
  • 2,600 stored procedures, averaging 180 lines each
  • 4,800 tables and 900 views
  • 350 SQL Agent jobs
  • Complexity split: 60% low, 30% medium, 10% high
  • Assessment output: a fixed price for the full estate and a recommended first domain of about 1,000 objects

Proof

SQL Server modernization in production

An AI-powered supply chain planning software company is moving its SQL Server estate to Delta Lake on a self-service Novuz rollout. The program covers 8,000 workflows.¹ The same engine and validation process applies to SSIS and Fabric.

Read the case studies

Pricing

Pricing for SSIS to Fabric

Pricing follows object count and complexity, not hours.

Estate assessment

$3,000. Three business days. Credited in full.2

First Domain

$25,000 to $40,000. 5 to 6 weeks on one domain of up to 1,500 components. Equivalence guarantee in writing.2

Full estate

Fixed from the assessment. Typically $40,000 to $200,000 for 1,500 to 10,000 objects, or an enterprise license for larger estates.2

See full pricing

Honest fit

Who should not choose Novuz

Novuz is not the right choice for estates under about 300 objects; for Oracle-only or mainframe estates; for teams with no target and no date inside 18 months; for buyers who want staff augmentation rather than software; or for organizations that cannot run software inside their environment or share code for an assessment.

FAQ

Frequently asked questions

  1. 1 An AI-powered supply chain planning software company, SQL Server to Delta Lake, self-service rollout. Definitions on the Methodology page.
  2. 2 Prices in USD as of the review date. Full terms on the Pricing page.

How we measure: Methodology

Last reviewed:

Find out what your logic debt is costing you.

Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.

Take the logic debt scorecard

Not sure which door? The scorecard takes ten minutes and tells you.

Scorecard