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

Announcing SSIS Data Flows and Administration Live, Online, Training Courses

I’m excited to announce fresh deliveries of two courses: 08-09 Apr 2020: SSIS Administration 13-14 Apr 2020: SSIS Data Flows Essentially, these courses are the first and second half of From Zero To SSIS. As I type (14 Mar 2020), both courses are on sale! Register for SSIS Data Flows or SSIS Administration today!These courses …
Continue reading Announcing SSIS Data Flows and Administration Live, Online, Training Courses

ADF Publisher Pending Changes Blade

There I was… writing a post titled ADF Wait Activity Wait Time Property is Now Dynamic. I had completed building a couple demo Azure Data Factory (ADF) pipelines and clicked the Publish All button. What did I see? Another new thing! Or at least, another update to ADF – the Publish All blade: If you …
Continue reading ADF Publisher Pending Changes Blade

ADF Wait Activity Wait Time Property is Now Dynamic

I am excited to see the “Wait time in seconds” property for the Azure Data Factory Wait activity is now dynamic. I admit: It doesn’t take much to excite me these days: “Why Do You Like This So Much, Andy?” I’m glad you asked! I deliver Azure Data Factory (ADF) training for Enterprise Data & …
Continue reading ADF Wait Activity Wait Time Property is Now Dynamic

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

Updating Default SSIS Values in the SSIS Catalog

A couple friends recently contacted me trying to solve a similar issue: how to update parameter values stored in the SSIS Catalog. One of my friends was interested in migrating their SSIS Catalog to a new server and needed to update several default SSIS parameter values stored in the SSIS Catalog. My answer here consists …
Continue reading Updating Default SSIS Values in the SSIS Catalog