Packaging SSIS Catalog Deployments

I love the SSIS Catalog. It’s an elegant piece of data integration engineering and I cannot say enough positive things about it. Packaging SSIS Catalog deployments can be tricky, though. The SSIS Catalog is a framework. Frameworks manage execution, configuration, and logging; and the SSIS Catalog handles each task with grace. Like I said, I …
Continue reading Packaging SSIS Catalog Deployments

Catalog Browser v0.7.8.0

I’ve been making smaller, more incremental changes to SSIS Catalog Browser – a free utility from the Data Integration Lifecycle Management suite (DILM Suite). You can use SSIS Catalog Browser to view SSIS Catalog contents on a unified surface. Catalog Browser works with SSIS Catalogs on-premises and Azure Data Factory SSIS Integration Runtime, or Azure SSIS. It’s …
Continue reading Catalog Browser v0.7.8.0

Viewing SSIS Configurations Metadata in SSIS Catalog Browser

SSIS Catalog Browser is a pretty neat product. “How neat is it, Andy?” I’m glad you asked. It’s free. That makes it difficult to beat the cost. SSIS Catalog Browser is designed to surface all SSIS Catalog artifacts and properties in a single view. “What exactly does that mean, Andy?” You’re sharp. Let’s talk about why …
Continue reading Viewing SSIS Configurations Metadata in SSIS Catalog Browser

Viewing SSIS Configurations Metadata in SSMS

Let’s take a look at an SSIS Project in SSMS: Demo is the SSIS Catalog folder. Demo contains three SSIS projects named 0-Monolith, EmptySSISProject, and LiftAndShift. If we expand the LiftAndShift SSIS project we see it contains a single SSIS package named Load Customer.dtsx. The Demo folder contains two Catalog environments named env1 and env2. These …
Continue reading Viewing SSIS Configurations Metadata in SSMS

Introducing Azure Data Factory Design Patterns

I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns

Announcing the Fundamentals of Azure Data Factory Course!

I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!