
SQL Server and SSIS to Microsoft Fabric: An 8-Day Source-Connected Migration Assessment for a P&C Insurer
SQL Server and SSIS migrations to Microsoft Fabric need clear source visibility before execution begins. For a US property and casualty insurer, the source estate included on-premises SQL Server 2019, SSIS-based ETL, stored procedures, views, SSIS packages, and SQL Agent jobs supporting policy and claims analytics. The migration had to preserve complex business logic while moving toward Fabric's hybrid Warehouse and Lakehouse pattern. The team needed a plan it could act on, not another high-level strategy document. The 8-business-day Modernization Canvas read the estate directly, produced source-connected inventory, scored object-level Fabric Warehouse compatibility, classified SSIS packages by migration approach, designed the hybrid target architecture, and reviewed representative T-SQL to Fabric T-SQL conversions under senior architect oversight.
Modernization Canvas
