Ssis-304 ~upd~

Configuring SSIS-304 is a straightforward process that involves several steps:

If you’re interested, I can also draft a quick that builds a minimal lineage cache for a single package, or walk you through adding a custom “Rule” plug‑in (e.g., enforce naming conventions). Just let me know! ssis-304

| 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. | | SSIS‑304 hooks into the project’s