Windows Desktop App

Inspect, validate, execute, and profile SSIS packages with Pygmy app

COZYROC Pygmy for Windows is a free desktop app for inspecting .dtsx, .dtproj, and .ispac files, validating SSIS packages, and executing and profiling them with DTEXEC.

Get it from Microsoft

Microsoft Store release coming soon.

or Download MSI

Features

  • Inspect the SSIS package control flow, data flow, parameters & variables, events in a Visual Studio-like viewer.
  • Windows Explorer file associations for .dtsx, .dtproj, and .ispac files.
  • Quickly reopen a SSIS package or project in Visual Studio. When a package is not a part of an SSIS project, automatically create a project.
  • Validate, execute, or profile the selected package with DTEXEC directly from the Windows app.
View feature matrix

Software Requirements

  • Requires 64-bit Windows 11 or Windows 10 (version 2004 or later).
  • Microsoft Store: coming soon
  • .msi: installer requires the WebView2 runtime available if it is not already present through the operating system.
  • For Open in VS functionality, you would need a compatible Visual Studio edition with SSIS Projects support.
  • For Execute and Profile functionality, you would need a compatible SQL Server Integration Service.