Description
SSIS Catalog Compare is part of the DILM Suite Bundle:
Stop babysitting jobs.
Start running SSIS like an enterprise application with SSIS Framework.
SSIS Catalog Compare scripts folders, projects, packages, environments, and configurations into deployable artifacts so your team can reduce deployment friction, improve visibility, and manage SSIS Catalog lifecycle with more control.
- Script SSIS Catalog folders, projects, and packages
- Capture environments and configurations
- Generate SCCPAC and CATPAC deployment artifacts
- Pair with DILM Deployment Utility for controlled deployment
- Reduce uncertainty between source and target environments
Instant download. Includes SSIS Catalog Compare and documentation.
Why this matters
Your SSIS packages may work in development and still fail in production because the real problem is often not the package alone. It is the lifecycle around the SSIS Catalog: missing environments, inconsistent configurations, unclear changes, incomplete deployments, manual rework, and hidden operational risk.
SSIS Catalog Compare helps you script catalog state into deployable artifacts so your team can see more, trust more, and move changes across environments with less guesswork.
What it helps you do
- Script SSIS Catalog content into reusable deployment artifacts
- Capture environments, variables, and configuration state
- Reduce drift caused by manual recreation and ad hoc changes
- Improve visibility before promoting Catalog changes
- Support more governed SSIS lifecycle execution
What SSIS Catalog Compare scripts
- Folders
- Projects
- Packages
- Environments
- Environment variables and configurations
- Catalog metadata required for governed deployment
Artifact outputs
- SCCPAC for selected SSIS Catalog content
- CATPAC for full-catalog scripting and deployment workflows
How it fits your SSIS lifecycle
- Script Catalog state
Capture SSIS Catalog structure and configuration into portable deployment artifacts. - Package changes cleanly
Generate SCCPAC or CATPAC outputs your team can move with more consistency. - Deploy with more control
Use DILM Deployment Utility to promote Catalog changes with less manual recreation. - Reduce Dev-to-Test-to-Prod friction
Bring more clarity and repeatability to SSIS Catalog change management.
Who this is for
Data Engineering Teams
Managing SSIS Catalog deployments across shared environments.
Consultants
Supporting enterprise SSIS estates that require clearer deployment control.
Organizations with Dev/Test/Prod complexity
Needing better alignment between source and target environments.
Teams modernizing carefully
Keeping SSIS running safely while improving lifecycle discipline.
What you get
- SSIS Catalog Compare
- Documentation
- Support for scripting SCCPAC and CATPAC deployment artifacts
- Immediate download after purchase
Choose the Right Fit for Your Team
Select the license that fits your team and operating model.
Choose your team size and license option to get started.
Annual is the fastest path to adoption. Perpetual is ideal for longer-term SSIS lifecycle operations.
| Team Size | Annual (Best Value) | Perpetual + 1 Year Support |
|---|---|---|
| Individual (1) | $2,290 / year | $9,778 initial purchase |
| Team (4) | $6,870 / year | $29,335 initial purchase |
| Department (10) | $16,030 / year | $68,436 initial purchase |
Annual is the easiest way to get started for immediate access, updates, and support. Perpetual is best for organizations standardizing long-term and managing maintenance internally.
Take control of SSIS Catalog changes before drift, manual recreation, and incomplete deployments create the next production problem.
Script cleanly, package consistently, and move Catalog changes with more confidence.
Planning a broader SSIS rollout?
We help teams standardize SSIS across environments, projects, and departments.
For broader rollouts, we support licensing, architecture, deployment, and lifecycle management.
Built by the DILM Suite Team, led by Microsoft Data Platform expert, author, and conference speaker, Andy Leonard.
FAQ
What do I receive after purchase?
You receive immediate access to SSIS Catalog Compare and supporting documentation.
What does SSIS Catalog Compare script?
It scripts folders, projects, packages, environments, environment variables, configurations, and related Catalog metadata into deployable artifacts.
What are SCCPAC and CATPAC?
SCCPAC captures selected SSIS Catalog content. CATPAC supports full-catalog scripting and deployment workflows.
Should I choose Annual or Perpetual?
Choose Annual for lower upfront cost and ongoing updates. Choose Perpetual for longer-term ownership with first-year support included.
Who is this designed for?
It is designed for teams managing SSIS Catalog changes where consistency, visibility, and deployment control matter.
Does this support enterprise rollout?
Yes. Enterprise licensing and lifecycle advisory are available for broader deployments.
