SnowConvert AI - ETL Replatform Component Summary Report

The Component Summary Report provides a comprehensive inventory of all identified SSIS components and their migration outcomes. Use this report to understand the overall migration scope and identify areas requiring attention.

Report Fields

FieldDescription
SessionIDUnique identifier for the migration run
TechnologyOriginal ETL technology (SSIS)
CategoryComponent category (Component, Package, Data Flow, Control Flow)
SubtypeComponent type (e.g., Microsoft.OLEDBSource, Microsoft.DerivedColumn)
FullNameFull component name including hierarchy (e.g., Package1/DataFlow1/Component1)
FileNameRelative path to the DTSX file
StatusMigration status (Success, NotSupported, Partial)
EWI CountNumber of EWIs for this component
EWIsUnique EWI codes found in the component
FDM CountNumber of FDMs (functional difference messages)
FDMsUnique FDM codes found in the component
PRF CountNumber of PRFs (performance warnings)
PRFsUnique PRF codes found in the component

How to Use This Report

Use the Status column to prioritize your post-migration work:

  • NotSupported status or high EWI counts indicate components that require manual intervention
  • Partial status means the component was converted but has limitations or warnings that need review
  • Success status indicates a clean conversion with no known issues

Example CSV

:force:

Technology,Category,Subtype,FullName,FileName,Status,EWI Count,EWIs,FDM Count,FDMs,PRF Count,PRFs
SSIS,Component,Data Flow Task,Customer ETL,Package.dtsx,Success,0,,0,,0,
SSIS,Component,Microsoft.OLEDBSource,OLE DB Source,Package.dtsx,Success,0,,0,,0,
SSIS,Component,Microsoft.DerivedColumn,Derived Column 1,Package.dtsx,Success,0,,0,,0,
SSIS,Component,Microsoft.Lookup,Lookup 1,Package.dtsx,Partial,0,,1,SSC-FDM-SSIS0001,0,