InvestorsCareersClient support
TulanFabric + Agentic AI
Technology

1,200 SSIS packages migrated to Fabric in 14 weeks

A multinational IT services firm moved its internal finance and delivery analytics off an aging SSIS and SQL Server estate, with automated parity proof on every table.

Data FactorySparkWarehouseSSISLoom ForgeLoom Sentinel

The challenge

Two decades of acquisitions left the company with 1,200 SSIS packages across 14 SQL Server instances, many undocumented. A previous partner estimated 11 months and 40 contractors to migrate. Leadership needed consolidated delivery margin reporting for a new fiscal year.

What we did

Loom Scout inventoried and scored every package, surfacing 212 that were obsolete. Loom Forge converted 83 percent of the remaining packages to Fabric Data Factory and Spark notebooks automatically. A Tulan pod of six engineers hardened the rest. Loom Sentinel reconciled every table nightly against source, so each of five migration waves went live with evidence rather than hope.

14 wksvs. an 11-month manual estimate
1,200SSIS packages converted
99.98%row-level parity at cutover
38%lower annual platform cost

The outcome

The program finished in 14 weeks with a team a fraction of the size originally quoted. Margin reporting that used to reconcile in eleven business days now closes in two. The company decommissioned 14 SQL Server instances and redeployed the savings into AI initiatives.

“We budgeted for a year of pain. Tulan gave us a quarter and a parity report for every table.”
Group CIO, Corporate Functions

Let's put agents to work on your Fabric estate.

Book a 45-minute working session with a Tulan architect. Bring your hardest data problem; leave with a plan.