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
Category:DILM
SSIS and the Future – December 2020 Edition
My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition
Foreword – Building Custom Tasks for SSIS 2nd Edition
I’m excited to announce Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 2nd Edition is available for pre-order at Amazon! I spent more time on this book and the demo task – the Execute Catalog Package Task – than any other book I’ve authored or …
Continue reading Foreword – Building Custom Tasks for SSIS 2nd Edition
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
One Reason to Avoid SSISDB Backup and Restore
First, please do not misunderstand. You should back up SSISDB just like you back up all other databases – especially in Production. You should also conduct Disaster Recovery exercises in which you restore SSISDB from the latest backup, or avail yourself of Always On availability groups and / or Windows Server Failover Clustering. To demonstrate …
Continue reading One Reason to Avoid SSISDB Backup and Restore
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