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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"package_path": "<package_path>"
},
"name": "analyze_ssis_package"
}
}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"]}. |