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

New Article: Help for DBAs Who Support SSIS at SQL Server Central

My latest article, Help for DBAs Who Support SSIS… is now live at SQL Server Central!

In this article I share some tips and tricks for using SSIS Catalog Compare for surfacing SSIS Catalog metadata, comparing SSIS projects deployed to different SSIS Catalog, and Scripting SSIS Catalog configurations metadata (such as Environments, Environment Variables, References, and Reference Mappings).

SSIS Catalog Compare is part of the DILM Suite (or Data Integration Lifecycle Management Suite) which is designed to support data integration automation. Although SSIS Catalog Compare is not free, most of the tools and utilities at DILM Suite are free – and some are open source.

I invite you to check out the tools and utilities at DILM Suite. I’d love your feedback, and please use the Contact page to send us your questions.


Learn More:

Designing an SSIS Framework (recorded webinar, registration required)
Biml in the Enterprise Data Integration Lifecycle (recorded webinar, registration required)
Enterprise SSIS, Biml, and DILM - 18 Jul 1:00 PM EDT - free webinar

Need Help or Training?

Enterprise Data & Analytics is here to help!
We provide SSIS and Biml training, and
SSIS Consulting and Performance Tuning.

Published Tuesday, June 20, 2017 9:30 AM 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