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.
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.

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.