DTSX VIEWER

See your SSIS packages the way you designed them — without opening Visual Studio.

An EpicData tool · Turning Data into Insights

WHAT IT DOES

DTSX Viewer is a custom editor for SQL Server Integration Services (.dtsx) packages. Open any .dtsx file in VS Code and, instead of raw XML, you get a clean, interactive, designer-style view of the package — control flow, data flows, connections, variables, and the SQL behind every task.

No SSDT, no Visual Studio, no SSIS runtime required. It reads the package XML directly.

FEATURES

• Control Flow — every task laid out top-down in execution order, with precedence constraints drawn as colour-coded elbow connectors (green = success, red = failure, blue = completion). Automatic crossing-reduction and distributed connection points keep large packages readable.
• Data Flow — one tab per Data Flow Task, showing sources, transformations and destinations connected by their paths, in true execution order.
• Clean routing — orthogonal elbow arrows with rounded corners; when several arrows meet one box they attach at separate points instead of overlapping.
• Execute SQL Tasks — the full SQL statement with syntax highlighting and a one-click Copy button, the resolved connection, and all parameter mappings.
• Column lineage — click any data-flow component to see its input and output columns and a column mapping table (upstream output → input → destination column).
• Connection Managers & Variables / Parameters — listed with their types, values and connection strings.
• Light & dark themes — toggle with the ☀ / ☾ button in the top-right; your choice is remembered.
• Export — save the current Control Flow or Data Flow as SVG or PNG straight into your documentation.
• Inspect anything — click a task, component or connection to see its properties. Pan with the mouse, zoom with the wheel.

HOW TO USE

1. Open any .dtsx file — it opens directly in DTSX Viewer.
2. Use the tabs to switch between Control Flow, each Data Flow, Connection Managers and Variables.
3. Click a box to inspect it in the Properties panel on the right — drag the panel's left edge to resize it (your width is remembered).
4. Double-click a Data Flow Task (or use its tab) to open its data flow.
5. Switch light / dark with the ☀ / ☾ button; export the current diagram with ⤓ SVG or ⤓ PNG (you choose where to save).
6. Pan by dragging the canvas, zoom with the mouse wheel or the ＋ / 1:1 / − controls.
7. Need the raw XML? Right-click the file → Open With → Text Editor.

INSTALLATION

Install the packaged .vsix:

• UI: Extensions panel → … menu → Install from VSIX… → select the file.
• CLI: code --install-extension dtsx-viewer-<version>.vsix

Then reload VS Code and open a .dtsx file.

CHANGELOG

1.0.0

• First stable release. Visual viewer for SSIS .dtsx packages covering SQL Server 2008 through 2022 (both the legacy property-element and modern refId formats): top-down control & data flow with container expansion and clean elbow routing, the full official task/transformation catalogue, Execute SQL Task SQL + parameter values, Script Task C#/VB code, column lineage, connection managers (incl. project-level references), variables, light/dark themes, resizable panel, SVG/PNG export, and a package-version badge.

0.28.0

• Package version shown in the header — a badge next to the package name shows the SSIS / SQL Server version and PackageFormatVersion (e.g. "SSIS 2022 · format v8", "SSIS 2008 · format v3"), derived from LastModifiedProductVersion/PackageFormatVersion. Hover for the exact product build.

0.27.0

• Data Flow Tasks inside containers now get a tab — a Data Flow Task nested in a Sequence / Foreach / For Loop container is now discovered at any depth and shown as its own tab (previously only top-level data flows were listed).

0.26.0

• Containers now expand — Sequence, For Loop and Foreach Loop containers are drawn as titled frames with their child tasks (and the precedence between them) laid out inside, recursively for nested containers. Previously a container showed as a single box with its contents hidden.

0.25.0

• Legacy SSIS 2008 packages supported (PackageFormatVersion 3 / SSIS.Package.2). Reads metadata stored as <DTS:Property> elements (names, IDs, descriptions, connection strings), handles the older layout with no collection wrappers, and parses the legacy precedence model (<DTS:Executable IDREF DTS:IsFrom>). These packages previously showed "Unnamed / No tasks found".

0.24.0

• Complete SSIS component coverage — every official control-flow task now gets a proper label and colour: data-preparation (File System, FTP, Web Service, XML, Data Profiling, CDC Control, Hadoop), workflow (Execute Package/Process/SQL-Agent-Job, Expression, Message Queue, Send Mail, WMI), SQL Server (Execute SQL, Bulk Insert), scripting (Script Task), Analysis Services & Data Mining, all Maintenance tasks, all Transfer tasks, and the Azure Feature Pack. Matched by type name so both short and fully-qualified types resolve. (Data-flow sources/transformations/destinations were already covered for every component, including custom ones, via structural classification.)

0.23.0

• Script Task support — Script Tasks are now recognised (including fully-qualified .NET type names used by older packages) and the embedded C# / VB script (ScriptMain) is shown in the Properties panel with syntax highlighting and a Copy button, plus the language and project-item list. Task type labels/colours also resolve correctly for fully-qualified types.

0.22.0

• Theme & panel-width preferences are now global — your light/dark choice (and the Properties-panel width) are remembered across all packages, not just the one you set them in.

0.21.0

• Resizable Properties panel — drag its left edge to set the width; the choice is remembered.

0.20.0

• Connection Managers tab now also lists project-level / referenced connection managers (defined outside the .dtsx), with name, scope, refId and usage count.

0.19.0

• Execute SQL Task Parameter Mappings now show the resolved value of each mapped parameter ($Project::* read from the sibling Project.params, $Package::* and User::* from the package). Project parameters are also listed in the Variables tab.

0.18.x

• Marketplace-ready: EpicData End-User License Agreement (free to use, distributable), EpicDataNV publisher, 128×128 PNG icon.

0.17.0

• Control-flow task colours matched to the vivid data-flow palette for consistent contrast.

0.16.0

• Orthogonal elbow connectors with distributed connection points (arrows no longer overlap into one spot).
• Export the current Control Flow or Data Flow as SVG or PNG.

0.15.0

• Light / dark theme toggle (remembered between sessions).

0.7.0 – 0.14.0

• Top-down layout for both flows with automatic crossing-reduction.
• Data-flow paths drawn in execution order; component input/output columns and column lineage mappings.
• Branded icon, documentation, and a reusable build script.

0.1.0 – 0.6.0

• Initial release: visual Control Flow and Data Flow, Execute SQL Task details with SQL syntax highlighting and copy, Connection Managers and Variables tabs, pan/zoom, and a properties panel.

ABOUT EPICDATA

EpicData is a Belgian data consultancy helping organisations build a data-driven culture — from strategy and governance to platforms, engineering and visualisation.

epicdata.be · Data doet dat.

LICENSE

© 2026 EpicData. Free to download and use (personal or commercial) under the EpicData End-User License Agreement. EpicData retains ownership; modifying, reverse-engineering, reselling, or redistributing the Software outside the official channels is not permitted. See LICENSE.txt.