Discover all SSIS packages (.dtsx files) from a given source. Returns a JSON list of found packages with name, path, and basic metadata. source_type must be one of: 'local', 'git', 'sql'.

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.

Convert a single SSIS package (.dtsx file) to Azure Data Factory JSON artifacts. Generates: pipeline JSON, linked service JSONs, dataset JSONs, mapping data flow JSONs, trigger JSONs, and Azure Function stubs for Script Tasks. Supports Self-Hosted IR, Key Vault secrets, Microsoft Recommended linked service format, schema remapping, ESI reuse detection, CDM pattern flagging, and cross-package dedup. Returns a summary of generated files and any warnings.

Validate ADF JSON artifacts in a directory for structural correctness. Checks that required fields (name, properties, activities) are present. Returns a list of validation issues found, or a success message if all artifacts are valid.

Deploy ADF JSON artifacts from a local directory to an Azure Data Factory instance. Deploys in correct dependency order: linked services → datasets → data flows → pipelines → triggers. Triggers are deployed in Stopped state and must be activated manually. Uses DefaultAzureCredential (az login, managed identity, or service principal env vars).