SSIS Catalog Reports – Operations Report

I recently added an Operations Report to DILM Suite‘s SSIS Catalog Reports solution. To acquire your very own copy of SSIS Catalog Reports – a free and open-source SQL Server Reporting Services (SSRS) solution – visit DILM Suite: Scroll until you find the link to SSIS Catalog Reports, and then click the link: The new …
Continue reading SSIS Catalog Reports – Operations Report

SSIS Catalog Execution Ended Unexpectedly

There are a handful of reasons for an “Ended Unexpectedly” package execution status in the SSIS Catalog. One reason is: the SSIS package was reporting a “Running” status when the SQL Server instance started. I can hear some of you thinking,… “How Did I Get Here?” The day earlier, I was testing some new SSIS …
Continue reading SSIS Catalog Execution Ended Unexpectedly

How to Promote SSIS Code in the Enterprise Lifecycle

I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have sysadmin privileges. 2. Test – another environment in which developers have sysadmin privileges. 4. Production – managed by production operations such as domain administrators, system administrators, …
Continue reading How to Promote SSIS Code in the Enterprise Lifecycle

SSIS Catalog Compare vNext Preview

I am happy to announce that the next version of SSIS Catalog Compare is officially in Preview! What exactly does “Preview” mean? I’m glad you asked. It means I am sharing copies of SSIS Catalog Compare with users of the current version to get their feedback, find bugs, and help identify improvements. Here’s a screenshot: …
Continue reading SSIS Catalog Compare vNext Preview

SSIS Catalog Browser v0.6.4.0 Released

“There I was…” happy as a clam, rolling right along in my free webinar titled “Introduction to Lifting and Shifting SSIS to the Cloud” (you can view the recording if you missed it [registration required]). I opened Catalog Browser to show off this free utility from DILM Suite and “Guess what my code did?” “Exactly what you …
Continue reading SSIS Catalog Browser v0.6.4.0 Released

Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018

Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018

Parsing SSIS Catalog Messages for Lookup Performance, v2

A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups. I’ve updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalog’s default Logging Level). Some smart data integration people recommend setting the SSIS Catalog Logging Level to Verbose and …
Continue reading Parsing SSIS Catalog Messages for Lookup Performance, v2

Coming Soon: SSIS Catalog Compare Updates

I spent a lot of time this year writing and managing a book project. I will blog about that later, I promise. While I enjoy writing it really cuts into my play time. What do I do when I play? I write software. This weekend I cracked open the code for SSIS Catalog Compare and …
Continue reading Coming Soon: SSIS Catalog Compare Updates