scan_ssis_packages
Scan and discover SSIS packages (.dtsx files) from local directories, Git repositories, or SQL Server databases to identify ETL components for analysis and modernization.
Instructions
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'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source_type | Yes | Where to find .dtsx files. | |
| path_or_connection | Yes | For 'local': absolute filesystem directory path. For 'git': repository URL or local path. For 'sql': SQL Server connection string or 'SERVER=...;DATABASE=msdb'. | |
| recursive | No | Search subdirectories (local/git only). Default: true. | |
| git_branch | No | Branch to check out (git source only). Default: 'main'. | main |