The SSIS Catalog and SCCPAC Files

The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files

Free Training for People Who Have Lost Their Jobs

Update 4 Apr 2020: To qualify for this offer you must enter your name and email in the form below and click the Submit button. Update 5 Apr 2020: Comments (for this post) have been closed. I saw a tweet earlier today from another friend who has been laid off as a result of COVID-19, …
Continue reading Free Training for People Who Have Lost Their Jobs

Source-Control SSIS Catalog Contents in Azure DevOps

I did a thing – actually a couple things – that I’ve been dreaming about for a while. In a couple recent blog posts – SSIS Catalog Compare Enterprise Generates SCCPAC Files and Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps – I walked through one way to source-control the …
Continue reading Source-Control SSIS Catalog Contents in Azure DevOps

Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps

I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control Azure DevOps, Software Development, and Git …
Continue reading Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps

SSIS Catalog Compare Enterprise Generates SCCPAC Files

SSIS Catalog Compare Enterprise Edition ships with the SCCPAC Deployment Wizard. The SCCPAC Deployment Wizard simplifies deploying the contents of an SSIS Catalog folder to an SSIS Catalog, whether on-premises or in the cloud: Configure SCCPAC File Location To configure the location for SCCPAC files, click View–>Options to open SSIS Catalog Compare’s Options dialog: Click …
Continue reading SSIS Catalog Compare Enterprise Generates SCCPAC Files

Four Free ADF Webinars

I just finished removing the latest appointment to attend an event from my calendar. A lot of awesome community events are being postponed or canceled. Let’s face it: the news stinks these days. What can we do about it? We can have free webinars online! Let’s Do This! Enterprise Data & Analytics is excited to …
Continue reading Four Free ADF Webinars

For a Limited Time: Use SSIS Catalog Browser to Manage DtsConfig Files

For a limited time, I am making DtsConfig Management – a feature of SSIS Catalog Compare – available in the latest (free) version of SSIS Catalog Browser. Am I awesome? Well, no. I am not awesome. This feature could use more testing. I can hear some of you thinking,… “Why Do I Need to Manage …
Continue reading For a Limited Time: Use SSIS Catalog Browser to Manage DtsConfig Files

SSIS Catalog Browser v0.9.2.1

I added Catalog Statistics to the latest version of SSIS Catalog Browser – version 0.9.2.1. I like the idea for a number of reasons but I am definitely biased; I built it. There are additional improvements over the previous release, but the improved performance from v0.9.1.0 is still there. Take SSIS Catalog Browser version 0.9.2.1 …
Continue reading SSIS Catalog Browser v0.9.2.1

Announcing SSIS Catalog Browser v0.9.1.0

I am excited to announce a fairly substantial update to SSIS Catalog Browser! What’s New? In a word, speed. The #1 complaint I received from customers using previous versions of SSIS Catalog Browser – especially customers with more than a few SSIS packages and projects in their SSIS Catalog – was related to the amount …
Continue reading Announcing SSIS Catalog Browser v0.9.1.0