On Broken References in the SSIS Catalog

I recently made this video to explain what I call “broken references” in the SSIS Catalog. In the video, I create and test a broken reference, and then demonstrate how SSIS Catalog Browser (and SSIS Catalog Compare) visualize broken references. Enjoy! What is a Broken Reference? It may help to define reference first. An SSIS …
Continue reading On Broken References in the SSIS Catalog

SSIS Catalog Browser v0.9.12.0

When I tinker with SSIS Catalog Compare, SSIS Catalog Browser is affected. SSIS Catalog Browser is free, SSIS Catalog Compare is not free. I recently used SSIS Catalog Compare on a consulting engagement to migrate contents of an SSIS Catalog from one server to another. During the migration, I found references were not processed as …
Continue reading SSIS Catalog Browser v0.9.12.0

SSIS Catalog Browser v0.9.10 is Available

I am excited to share the latest release of SSIS Catalog Browser, and it’s still free at DILM Suite! A feature I forgot to mention in the video is the “Check for Update” menu item: If you are running the current version – beginning in version 0.9.10.0 – clicking Help>Check for Update will display a …
Continue reading SSIS Catalog Browser v0.9.10 is Available

SSIS Catalog Browser v0.9.9.3

I am happy to announce the availability of SSIS Catalog Browser v0.9.9.3. SSIS Catalog Browser is free. You are welcome. This post is part of a series about SSIS Catalog Security. The other posts in this series are: One Way to Create an SSIS Catalog Read-Only Database Role One Way to Set SSIS Catalog Security …
Continue reading SSIS Catalog Browser v0.9.9.3

SSIS Catalog Browser v0.9.9.0 is Available

I am excited to announce the latest release of SSIS Catalog Browser! SSIS Catalog Browser version 0.9.9.0 is free and features enhanced Folder, Project, and Package Properties, surfacing Description, Validation Status, and Last Validation Time properties: These same properties – Description, Validation Status, and Last Validation Time – are now also included in the scripting …
Continue reading SSIS Catalog Browser v0.9.9.0 is Available

Wrapping Up 2020

It’s that time of year again; that time when bloggers and others share their thoughts about the year that was and the year to come. “2020 was ____.” I complete this sentence three ways, listed below. Feel free to add your thoughts in the comments. “Different” …is the first word that leaps to mind. The …
Continue reading Wrapping Up 2020

Environment Properties Node for Catalog Browser

I’ve been working on SSIS Catalog Compare and its free counterpart SSIS Catalog Browser. Earlier I added Folder and Project Properties nodes, more recently I added Environment Properties: Environments are… tricksy. Why? Because of broken references. I can hear some of you thinking,… “What’s a broken reference, Andy?” That’s an excellent question – I’m glad you …
Continue reading Environment Properties Node for Catalog Browser

Folder and Project Properties Nodes for Catalog Browser

I’m happy to announce the addition of Folder Properties and Project Properties nodes to SSIS Catalog Browser, a free utility from DILM Suite that surfaces a unified view of the SSIS Catalog: As ever, the same functionality is available in SSIS Catalog Compare. Contact Enterprise Data & Analytics to learn more. Enjoy! :{> Need Help? …
Continue reading Folder and Project Properties Nodes for Catalog Browser

SSIS Catalog Browser Live Demo

I am delivering more and more live streaming sessions. The session for today (6 Oct 2020) was all about SSIS Catalog Browser, a free utility from DILM Suite. DILM Suite hosts several utilities to help with Data Integration Lifecycle Management (DILM). Most are free and many are open source. You should check it out! Enjoy …
Continue reading SSIS Catalog Browser Live Demo