Join me at 12:00 PM EDT on 9 Jul 2020 for Building an SSIS Framework in ADF, another free Summer o’ ADF webinar from Enterprise Data & Analytics. Abstract Andy authors SSIS frameworks according to a few principles: 1. Functionality 2. Empathy 3. Simplicity Join Microsoft Data Platform MVP Andy Leonard as he discusses and …
Continue reading Free Webinar – Building an SSIS Framework in ADF
Category:DILM Suite
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
Azure DevOps and the SSIS Development Lifecycle Recording is Available!
Azure DevOps and the SSIS Development Lifecycle was recorded 3 Apr 2020. Enjoy! :{>
Free Training for People Who Have Lost Their Jobs
Update: I am unable to offer free training to people who lost their job due to the pandemic at this time. Thank you to everyone who took advantage of this offer. I hope the training helped. – Andy I saw a tweet earlier today from another friend who has been laid off as a …
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