THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017!

The Data Integration Lifecycle Management Suite (DILM Suite) helps SSIS Developers and Database Administrators manage SQL Server Integration Services (SSIS) deployments in the enterprise lifecycle.

Join Kent Bradshaw and me at 1:00 PM EST 7 Mar 2017 for the SSIS Catalog Compare v2.0 Launch Event! In this free webinar we will demonstrate the value of using the DILM Suite to practice Data Integration Lifecycle Management. Join us and learn how to :

  • “Walk” an SSIS project though several lifecycle tiers
  • Detect differences between SSIS projects deployed to Production and QA lifecycle tiers
  • Automate SSIS comparisons, scripting, and deployment between SSIS Catalogs
  • Detect broken references in the SSIS Catalog

What is the DILM Suite?

Visit the DILM Suite website for a full list of the (mostly free!) tools! I can hear you thinking, “What does mostly free mean, Andy?” I’m glad you asked.

SSIS Catalog Browser, shown below, is free and surfaces a full view of SSIS Catalog objects in a single view:


The SSIS Framework Community Edition integrated into the SSIS Catalog to provided extended SSIS execution functionality. It’s not only free, it’s open source!


SSIS Framework Browser (… you guessed it, also free!) supports the SSIS Framework Community Edition by surfacing Framework Applications and Packages.


SSIS Catalog Compare is an application that helps DBAs and SSIS Developers support and maintain SSIS in the DevOps enterprise. Compare, script, and deploy SSIS Catalog objects between SSIS Catalogs with alacrity. SSIS Catalog Compare delivers value because the utility helps DBAs and SSIS Developers efficiently manage enterprise SSIS deployments and configurations.


CatCompare is the command-line interface for SSIS Catalog Compare. DBAs and SSIS Developers use CatCompare to automate SSIS Catalog comparisons, deployments, and  synchronization.


In the DILM Tools webinar, Kent Bradshaw and I will demonstrate using these tools to improve operational efficiency and automate SSIS management.

Register today!


I was honored to be interviewed by Carlos Chacon (@CarlosLChacon | SQL Data Partners) and Steve Stedman (@SqlEmt | Blog) for the SQL Data Partners podcast. We had a great discussion about the SSIS Catalog. We talked about how the SSIS Catalog works, Data Integration Lifecycle Management (DILM), SSIS Catalog Browser, SSIS Catalog Compare, and the Richmond SQL Server Community.

If you’ve never listened to the SQL Data Partners podcast, it’s awesome! My favorite part is the SQL Family questions at the end!



You might like working with Enterprise Data & Analytics because we grok the SSIS Catalog.

Learn More:
Broken References in the SSIS Catalog
SSIS Academy: Using the SSIS Catalog Day 1 - Create the Catalog and Deploy
SSIS Academy: Using the SSIS Catalog Day 2 - Package Execution and Monitoring
SSIS Academy: Using the SSIS Catalog Day 3 - SSIS Configuration
SSIS Catalog Management
SSIS Lifecycle Management

Related Training:
IESSIS1: Immersion Event on Learning SQL Server Integration Services – April 2017, Chicago 
IESSIS2: Immersion Event on Advanced Integration Services – Oct 2017, Chicago
From Zero to Biml - 19-22 Jun 2017, London

Published Monday, January 23, 2017 1:53 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement