SSIS Framework Manager CE Version 0.3 is Available

I made a few more changes to SSIS Framework Manager CE (Community Edition). The latest change is to add fields to specify the Database and Schema names. A customer shared that their enterprise considers the SSIS Catalog database – SSISDB – a system database (which I totally understand). At their request, I built a new collection of …
Continue reading SSIS Framework Manager CE Version 0.3 is Available

SSIS Framework Manager Community Edition Updated

I made a few changes to SSIS Framework Manager CE (Community Edition). The most impactful change is to the SSIS Framework Application Execute functionality. In the initial (alpha!) release, framework application executions – executed from SSIS Framework Manager CE (only) – timed out at 30 seconds. This was due to the default SqlCommand timeout and …
Continue reading SSIS Framework Manager Community Edition Updated

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework

Announcing SSIS Framework Manager CE (Community Edition)

I’m excited to announce SSIS Framework Manager CE (Community Edition) is available for download at DILM Suite! SSIS Framework Manager CE is designed to support SSIS Framework Community Edition, providing a GUI to facilitate SSIS Framework Application creation, configuration, and management. Three views are supported in this initial edition: Catalog, Application, and Package. The Catalog …
Continue reading Announcing SSIS Framework Manager CE (Community Edition)

Wrapping Up 2020

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

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

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