It’s that time of year again; that time when bloggers and others share their thoughts about the year that was and the year to come. “2020 was ____.” I complete this sentence three ways, listed below. Feel free to add your thoughts in the comments. “Different” …is the first word that leaps to mind. The …
Continue reading Wrapping Up 2020
Category:DILM Suite
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS
AWS and SSIS
Brent Ozar, my friend and brother from another mother, shared an interesting link on LinkedIn. The article Brent linked is titled Amazon RDS for SQL Server now supports the Business Intelligence Suite on SQL Server 2019. I find the topic interesting for a number of reasons. I’m interested in helping enterprises lift and shift on-premises …
Continue reading AWS and SSIS
Global Parameters in SSIS Framework
I’m happy to announce the latest version of our SSIS Framework includes global parameters! I can hear some of you thinking, … “What Are Global Parameters, Andy?” I’m so glad you asked! SSIS ships with package-scoped and project-scoped parameters. Project-scoped parameters may be used in any SSIS package in the project; package-scoped parameters are only …
Continue reading Global Parameters in SSIS Framework
Environment Properties Node for Catalog Browser
I’ve been working on SSIS Catalog Compare and its free counterpart SSIS Catalog Browser. Earlier I added Folder and Project Properties nodes, more recently I added Environment Properties: Environments are… tricksy. Why? Because of broken references. I can hear some of you thinking,… “What’s a broken reference, Andy?” That’s an excellent question – I’m glad you …
Continue reading Environment Properties Node for Catalog Browser
Folder and Project Properties Nodes for Catalog Browser
I’m happy to announce the addition of Folder Properties and Project Properties nodes to SSIS Catalog Browser, a free utility from DILM Suite that surfaces a unified view of the SSIS Catalog: As ever, the same functionality is available in SSIS Catalog Compare. Contact Enterprise Data & Analytics to learn more. Enjoy! :{> Need Help? …
Continue reading Folder and Project Properties Nodes for Catalog Browser
Biml Stream – 13 Oct 2020
I streamed about Biml earlier. And BimlExpress (which is free). And my BimlExpress Metadata Framework (which is also free). Enjoy! :{>
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 Browser Live Demo
I am delivering more and more live streaming sessions. The session for today (6 Oct 2020) was all about SSIS Catalog Browser, a free utility from DILM Suite. DILM Suite hosts several utilities to help with Data Integration Lifecycle Management (DILM). Most are free and many are open source. You should check it out! Enjoy …
Continue reading SSIS Catalog Browser Live Demo
Recording for Updates to the SSIS Framework Webinar
Enjoy this recording of the Updates to the SSIS Framework free webinar, delivered 30 Jul 2020 at 12:00 PM EDT. Learn more about the SSIS Framework at DILM Suite. Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our …
Continue reading Recording for Updates to the SSIS Framework Webinar