SSIS Analyzer

Professional SQL Server Integration Services Analysis & Documentation Tool

SSIS Analyzer loads SQL Server Integration Services projects, shows every element of each package, visualizes the control flow, lets you compare two versions, traces data lineage, and exports self‑contained HTML documentation.

Platform: Windows desktop app (.NET 9, WinForms)
Theme: Visual Studio dark theme

---

Features

✨ Complete Package Analysis

• Every element exposed: Properties, Parameters, Variables, Connections, Expressions
• Control flow visualization with precedence constraints
• Event handlers and data flow components
• SQL auto‑formatting and syntax‑highlighting

🔍 Cross-Project Capabilities

• Load multiple .ispac projects or individual .dtsx packages
• Load deployed projects directly from SSISDB catalog
• Compare two versions (before deploy validation)
• End‑to‑end data lineage analysis across all packages

📊 Lineage & Impact Analysis

• Table flow: source → target with package/task tracking
• Column-level lineage within data flows
• Package call graph (Execute Package Tasks)
• Impact analysis: upstream sources & downstream targets
• Transitive dependency tracking

📄 HTML Export

• Self‑contained documentation (no external dependencies)
• Project overview with embedded control‑flow SVGs
• Lineage reports with package flow graphs
• All tables, connections, and expressions documented

💾 Workspace Management

• Save/load named workspaces (.ssisws files)
• Auto‑persist current workspace between sessions
• Keep separate sets for DEV, PROD, handover

🔧 Automation & CI/CD

SsisAnalyzer.exe --dump    <project.ispac>                  Console summary
SsisAnalyzer.exe --export  <project.ispac> [outDir]         HTML documentation
SsisAnalyzer.exe --compare <a.ispac> <b.ispac> [out.html]   Comparison report
SsisAnalyzer.exe --lineage <project.ispac>                  Lineage analysis

---

Getting Started

1. Launch SsisAnalyzer.exe
2. Add Sources via File menu:
   • .ispac project files
   • Individual .dtsx packages
   • Deployed projects from SSISDB
3. Explore packages in the tree (left)
4. View control flow diagram (top‑right)
5. Export as HTML for documentation

First Run

• 30‑day trial starts automatically (fully featured)
• After trial ends: install license or exports are watermarked

---

Licensing

Period	Status
0–30 days	Trial (full functionality)
After trial	Licensed or watermarked exports

Install License:

• Help → About / License…
• Send Machine ID to vendor
• Install .lic file

---

Documentation

📖 User Manual MANUAL.md — Comprehensive guide with examples

---

System Requirements

• OS: Windows 10 / 11 / Server 2019+
• Runtime: .NET 9 Desktop Runtime
• SQL Server: 2012 or later (for SSISDB access)
• Memory: 4 GB recommended
• Disk: 500 MB for installation + working files

---

Support & Feedback

Report issues or suggest features on GitHub:
https://github.com/JankeUwe/SsisAnalyzer/issues

---

License

Proprietary. See LICENSE file for details.

© dtcSoftware · Janke
https://www.powershelldba.de