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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Keeping Up With Technology – Eugene Meidinger
In case you missed it, Eugene Meidinger (Blog | @SQLGene) recently delivered some fantastic advice spanning technology, critical thinking, and careers. Want more? Join Eugene 06 Mar 2020 for a day-long training event: Power BI: The Other 90%! Please find details here. Register today! :{>
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
Azure DevOps, Software Development, and Git Part 3 – Command-Line
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 In this post I cover command-line …
Continue reading Azure DevOps, Software Development, and Git Part 3 – Command-Line