Add the command SSIS‑304 /AutoRefresh to your build pipeline to keep the cache up‑to‑date on every CI build.
A that automatically captures, displays, and lets you explore the lineage of every data flow element in an SSIS project – from source to destination – and shows the downstream impact of any change (e.g., column rename, data‑type change, added transformation, or package removal). 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. | Add the command SSIS‑304 /AutoRefresh to your build
SSIS-304 is a component within the SQL Server Integration Services (SSIS) pipeline, specifically designed for error handling and troubleshooting. It is a task that allows users to capture and handle errors that occur during the execution of a package. With SSIS-304, users can configure various error handling options, including logging, email notifications, and task outcomes, making it easier to diagnose and resolve issues. | SSIS‑304 hooks into the project’s
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!
In the heart of the Pacific Ocean, there existed a mysterious island known as SSIS-304. The island was shrouded in secrecy, and its existence was only whispered among sailors and scientists. The name SSIS-304 was derived from the coordinates of the island: 30.4° North latitude and 124° East longitude.