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.
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 object | Fabric target |
|---|---|
| Control flow and precedence constraints | Data Factory pipeline activities and dependencies |
| Data flow tasks | Spark notebooks or Dataflow Gen2 |
| Execute SQL tasks | Warehouse stored procedures or notebook cells |
| Script Tasks / Components | Notebook code, flagged for resolver review |
| Stored procedures and functions | Fabric warehouse T-SQL or PySpark |
| Tables and views | Lakehouse Delta tables and warehouse views |
| Parameters and configurations | Pipeline parameters and variable libraries |
| SQL Agent jobs and schedules | Pipeline 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 studiesPricing
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
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 An AI-powered supply chain planning software company, SQL Server to Delta Lake, self-service rollout. Definitions on the Methodology page.
- 2 Prices in USD as of the review date. Full terms on the Pricing page.
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.
Not sure which door? The scorecard takes ten minutes and tells you.