analyze_ssis_package
Analyze SSIS packages to generate detailed reports on complexity, effort estimates, component inventory, and migration gaps for Azure Data Factory conversion.
Instructions
Analyze a single SSIS package (.dtsx file) and return a detailed report including: complexity score (0-100), effort estimate (Low/Medium/High/Very High), component inventory, gap analysis (items needing manual work), cross-database/linked server references, CDM pattern detection, ESI reuse candidates, and dependency execution order.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| package_path | Yes | Absolute path to the .dtsx file. | |
| esi_tables_path | No | Optional path to a JSON file mapping source_system → table list for ESI reuse detection. Format: {"PHINEOS": ["TocPartyAddress", "TLBenefit"]}. |