DTS Viewer

DTS Viewer enables developers and data engineers to examine DTS package structures, steps, and dependencies quickly without running the packages.

Tool coming soon!

We're working hard to get this tool ready for you.

Request Feature / Support
1,632+
Total Calculations Run
< 15ms
Browser Execution Speed
100%
Client-Side Privacy
4.9 / 5.0
User Satisfaction
AI Web Tool Generator

Build Your Own Custom Web Calculator in Seconds

Type what tool or calculator you need below. Our AI will build it instantly for your site.

Popular ideas:
100% FREE • No Credit Card Required

About This Tool

DTS Viewer provides a read-only inspection of DTS package definitions to reveal their data flows, steps, and dependencies. It does not execute the packages, but it renders a structured view that helps teams understand how data moves through each transformation. Conceptually, the tool parses the package, builds a graph of steps as nodes and data moves as edges, and then exposes metadata for each step (source, transformation, destination) without exposing sensitive details unless explicitly allowed. This makes it valuable for auditing, migration planning, and debugging in environments that rely on legacy DTS definitions. By offering multiple view modes, users can focus on the overall flow, the dependency graph, or error lists, and export the results for documentation or integration with other tools. The tool's unique value lies in combining precise package parsing with a stable, exportable representation of the ETL logic, enabling faster impact analysis and safer migrations. Core features include source input, mode selection, and detailed outputs; optional features include filtering, masking, version comparison, and region-aware formatting. Typical use cases include legacy DTS migration, ETL process auditing, and data lineage validation across environments.

How to Use

  1. Provide inputs: specify package_source, package_id, view_mode, include_sensitive, max_steps, and region if needed.
  2. Run analysis: parse the package to generate a structured model of steps, data flows, and dependencies.
  3. Review outputs: examine summary, step_details, and dependencies to understand the ETL logic.
  4. Inspect errors: check the errors list for any reported issues or warnings within the package.
  5. Export results: save as JSON, CSV, or YAML for documentation or tooling integration.
  6. Optional: compare with previous versions or mask sensitive data for sharing.
How to use dts viewer

Frequently Asked Questions

Find Quick Answers

What formats are supported?
The viewer reads legacy DTS packages (binary .dts and XML-based definitions). If a package is provided in an XML representation, the parser uses structural tags to extract steps and data flows. DTSX/SSIS formats are not guaranteed; XML representations of DTS definitions are preferred.
Can I export results?
Yes. Outputs can be exported as JSON, CSV, or YAML. Exports include the summary, step_details, and dependencies, enabling documentation and integration with other ETL tooling or data catalogs.
Is sensitive data masked?
When include_sensitive is false, connection strings and credentials are redacted in all outputs. You can enable full detail only for trusted environments with appropriate access controls.
Does it validate package integrity?
The tool performs structural validation, checks for missing steps, and detects simple cycles or invalid references. It does not execute packages or validate runtime semantics, and cannot guarantee successful execution.

Need to run multiple calculations?

Create a free account today to unlock unlimited daily runs, access advanced parameters, save your history, and request custom features.

Register Free Account

Related Tools

Other useful calculators and utilities you might like

Developer Tools

Spotify to MP3 Converter

Convert Spotify tracks and playlists to MP3 format instantly with our free online converter.

Developer Tools

Road Distance Calculator

Calculate the driving distance and travel time between two addresses with our free online road dista...

Developer Tools

Age Calculator

Calculate your exact age in years, months, and days from any birth date to any target date.

Developer Tools

Currency Converter

Convert currencies instantly with real-time exchange rates and historical data support.

Your Feedback Matters

Help Us to Improve