COZYROC Pygmy - DTSX Viewer

Explore SSIS packages and projects directly in Visual Studio Code, with a familiar designer view.

Free to use. No Visual Studio, SSDT, or SSIS runtime required.

Quick Start

1. Open a .dtsx, .dtproj, or .ispac file in Visual Studio Code.
2. If prompted, choose Open With... and select SSIS Package Viewer/COZYROC Pygmy. To switch to the default text editor that use Reopen Editor With....

COZYROC Pygmy in Visual Studio Code

Features Overview

• Open .dtsx, .dtproj, and .ispac files in a dedicated visual canvas, closely resembling the SSIS Designer experience in Visual Studio.
• Explore Control Flow, Data Flow, Parameters, Variables, and Event Handlers.
• Inspect detailed properties of connection managers, tasks, components, parameters & variables, event handlers, and more - including their underlying XML definitions.
• Quickly navigate package elements through cross-references. Browse and search within the package using the Package Explorer.
• Search within the contents of an entire SSIS project (.dtproj, and .ispac files) using the Project Explorer.

Files stay on your device

• Your SSIS packages are analyzed locally within VS Code—no package data is uploaded or shared.
• Optional telemetry can be disabled at any time through cozyrocPygmy.telemetry.enabled.

Notes

• Read-only viewer - editing of SSIS packages is not supported.
• Packages using EncryptAllWithPassword are not supported. The viewer does not attempt to decrypt or access encrypted sensitive data.
• Need to execute and profile SSIS packages? Or quickly open them in Visual Studio? Checkout the free desktop app.
• View the full feature list of COZYROC Pygmy apps and addons at here.

Support

• Click on the Feedback link in the viewer canvas to provide feedback or report issues.

Changelog

1.1.1 - 2026-10-22

Moved the Feedback button to a small icon in the bottom-right corner, so it no longer covers the Properties pane.
Added the changelog with release dates to the extension Overview page.

1.1.0 - 2026-10-20

Added Data Lineage tab showing the datasets read and written by data flow components and Execute SQL tasks, an upstream/downstream graph across the packages of a project, and column-level lineage through data flow transformations.
The Control Flow now opens with no task selected and shows the package properties; clicking an empty area of the canvas deselects the task and shows the package properties again.

1.0.19 - 2026-10-16

Added destination column mappings to the input of OLE DB, ADO.NET, ODBC, Flat File, Excel, and other destinations, highlighting unmapped columns and data type differences.
Added readable labels for enumerated properties of built-in components such as Lookup, Merge Join, Aggregate, Fuzzy Lookup, Term Extraction, and the ADO.NET, ODBC, and Excel adapters.
Improved visualization of the Lookup transformation with join, lookup, and reference columns, and parameter mappings shown as column names.
Added Result Set bindings to the Execute SQL Task and fixed repeated task settings showing only the last value.
Improved visualization of the Execute Package Task with reference type, parameter bindings, and a link to the child package in the same project.
Improved visualization of ForEach Loop containers with the ADO enumerator source variable and mode, multi-column Item enumerator values, and variable mappings ordered by index.
Added column mappings to Union All, Merge, and Merge Join, including Merge Join keys.
Added column details to Data Conversion, Aggregate, and Sort.
Added parameter mappings to OLE DB Command.
Added an indicator for components disabled for dynamic data flow in COZYROC SSIS+ Data Flow Task Plus.

1.0.18 - 2026-10-09

Rename extension to COZYROC Pygmy - DTSX Viewer
Fixed visualization of ForEach Loop containers, executed by COZYROC SSIS+ Parallel Loop Task.

1.0.17 - 2026-10-06

Fixed a regression issue of missing scroll in the Properties pane
Fixed missing project parameter values and descriptions, and improved the project parameters view.
Added package-name filtering and a Clear filters action to Project Explorer; search filters now reset when opening a new project.
Added a connection string popup with parsed properties and a copy action.
Improved "Used by" references with sortable lists and more specific item icons.
Improved task, component, and connection-manager icons, removed duplicate connection references, and aligned Package Explorer expand buttons.
Improved visualization of COZYROC SSIS+ Database Destination and EDI Connection Manager.

1.0.16 - 2026-09-18

Added Project Explorer for .dtproj and .ispac files - project-wide searching and reference analysis of tasks, components, connection managers, parameters, variables, and event handlers.
Fixed control-flow containers rendering wider than their saved design-time dimensions.
Fixed multiple cosmetic issues.

1.0.15 - 2026-08-14

Fixed Raw XML not preserving the original XML content and namespace prefixes from the SSIS package.
Fixed accidental removal of elements from the canvas via the delete button

1.0.14 - 2026-08-11

Updated the extension icon with COZYROC branding.
Introduce a changelog.

1.0.13 - 2026-07-29

Improved JSON Source metadata display, including JSON/JSON Lines values and readable encoding names.
Fixed JavaScript Task and JavaScript Component detection and property rendering; empty ParametersValues now displays as (none).
Treat tasks as disabled when the package root is marked as disabled, and move SSISPlusVersion to "Advanced" properties.

1.0.12 - 2026-07-17

Added new ParquetDestination enumeration values.
Fixed a regression with the extension display name.

1.0.11 - 2026-06-17

Added support for legacy SSIS package format v3 (SSIS 2008).

1.0.10 - 2026-06-15

Improved errors shown when DTSX files or browser uploads cannot be opened.

1.0.9 - 2026-06-12

Added Inputs and Outputs details to data-flow component properties and made data-flow property links navigable.
Added support for non-trusted workspaces.

1.0.8 - 2026-06-09

Improved disabled task and component visualization, Execute Package Task connection resolution, and ForEachFromVar mappings.

1.0.7 - 2026-06-01

Added detailed Table Difference input/output views and improved direct component-property rendering.

1.0.6 - 2026-05-29

Improved property rendering for Execute SQL parameters, OLE DB AccessMode, disabled tasks/components, and connection usage targets.

1.0.5 - 2026-05-28

Fixed control-flow layout, link styling, and reference matching.

1.0.4 - 2026-05-27

Made explorer indexing faster, displayed connection-manager usage, and fixed EXCEL+ component detection.

1.0.1 - 2026-05-08

Initial major release.

About

COZYROC simplifies enterprise data integration with powerful SSIS and cloud connectivity solutions. Connect virtually any system, automate data movement, and deliver projects faster with hundreds of ready-to-use, battle-tested connectors and integration components. Check out our COZYROC SSIS+ and our COZYROC Cloud.