Inscrivez-vous à notre newsletter et recevez immédiatement -10% sur toutes nos formations.
L'offre expire dans :
| Feature | Description | How it works | |---------|-------------|--------------| | | Visual directed‑graph (nodes = sources, transformations, destinations) rendered in the SSIS Designer. | SSIS‑304 hooks into the project’s .dtsx XML during design time, parses <DataFlow> metadata, and builds a graph stored in an internal SQLite cache. | | Impact‑Analysis Engine | When you edit a column (rename, type change, delete) the engine shows a “What‑If” impact list. | Uses the lineage cache to propagate schema changes downstream, flagging broken connections, mismatched data types, and downstream downstream tasks (e.g., Data Quality checks, stored‑proc calls). | | Version‑Aware Diff | Compare lineage between two project versions (e.g., before/after a release). | Stores a snapshot of the graph per project version; a diff view highlights added/removed nodes and changed edges. | | Export & Embed | Export graphs as PNG/SVG, PDFs, or embed as markdown tables. | UI button “Export” → chooses format → saves to solution folder or clipboard. | | Search & Filter | Find all usages of a column, table, or transformation quickly. | Text‑search box with auto‑complete; results highlight nodes and list packages/tasks. | | Custom Annotations | Add notes to any node (e.g., “Deprecated column – use X instead”). | Right‑click → Add Annotation → stored in the cache and persisted in the .dtsx as a hidden <Annotations> element. | | Security & Auditing | Role‑based view permissions + an audit log of who changed what and when. | Integrated with SSISDB security model; audit stored in the same SQLite cache and can be exported. |
| Layer | Technology | Key Points | |-------|------------|------------| | | .NET 6, Microsoft.SqlServer.Dts.Runtime | Reads the XML representation of .dtsx files; extracts <ConnectionManagers> , <DataFlow> , <Components> . | | Cache | SQLite (file ssis‑304.cache in the project root) | Fast look‑ups, diff, and diff‑merge support. | | Graph Engine | QuickGraph + GraphViz (for SVG rendering) | Generates directed‑acyclic graphs; layout is deterministic for diff stability. | | UI | WPF (for VS) + XAML + LiveCharts | Interactive node selection, pan‑zoom, tool‑tips. | | Impact Analyzer | Custom rule engine ( IRule ) that evaluates schema propagation | Runs on-demand; can be extended with user‑defined rules ( IRule plugins). | | Security | Integrated with SSISDB role‑based security; cache rows have CreatedBy , CreatedOn . | Auditing stored in same SQLite DB – exportable to CSV. | | Extensibility | MEF (Managed Extensibility Framework) | Third‑party developers can add new node types (e.g., custom script components) or new export formats. | ssis-304
SSIS-304 could refer to:
| Business Impact | Metric | |-----------------|--------| | after schema changes | ↓ 30‑40 % incident tickets | | Faster onboarding | ↓ 2 weeks average ramp‑up time | | Improved compliance | ✅ 100 % traceability for audit periods | | Higher code quality | ↑ 15 % fewer “broken package” bugs per release | | Documentation upkeep | ✅ Auto‑generated docs stay current | | Feature | Description | How it works