SSIS Framework Manager Property Overrides Video

I’m adding a GUI to DILM Suite called SSIS Framework Manager. If you read that name and guessed the GUI manages the SSIS Framework metadata, you are correct! I’ve been streaming as I’ve coded along on the project. I reached a pretty good functionality place earlier this week. Since then, I’ve been testing. I thought …
Continue reading SSIS Framework Manager Property Overrides Video

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

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