Fabric Data Factory Design Pattern – Parent-Child with Parameters

In an earlier post, I demonstrated one way to build a basic parent-child design pattern in Fabric Data Factory by calling one pipeline (child) from another (parent). In this post, I modify the parent and child pipelines to demonstrate calling a child pipeline that contains a parameter. In this post, we will: Clone and edit …
Continue reading Fabric Data Factory Design Pattern – Parent-Child with Parameters

Fabric Data Factory Design Pattern – Basic Parent-Child

The Microsoft Fabric Team released a new Invoke Pipeline Activity in September 2024. This post describes one way to implement a parent-child design pattern using the new activity. In this post, we will: Create a new workspace Build a child pipeline Build a parent pipeline Test Create a New Workspace Connect to Fabric Data Factory. …
Continue reading Fabric Data Factory Design Pattern – Basic Parent-Child

Use Azure Data Factory in Fabric Data Factory

Thanks to the hard work of the Microsoft Fabric Data Factory Team, it’s now possible to mount an Azure Data Factory in Fabric Data Factory. This post describes one way to mount an existing Azure Data Factory in Fabric Data Factory. In this post, we will: Mount an existing Azure Data Factory in Fabric Data …
Continue reading Use Azure Data Factory in Fabric Data Factory

SSIS Extension Updates – Sep 2024

Back in Jun 2024, I announced I was changing the way I report updates to the SQL Server Integration Services extension for Visual Studio (in a post titled SSIS Extension Updates – Jun 2024). Right on time, here’s the second quarterly update. There Are Two Integration Services Extensions I’m not sure why the decision was …
Continue reading SSIS Extension Updates – Sep 2024

Announcing SSIS Catalog Browser v0.9.20

Kent Bradshaw and I are excited to announce the availability of SSIS Catalog Browser v0.9.20! SSIS Catalog Browser is free and surfaces SSIS Catalog projects and configurations metadata in a single unified view. The latest version fixed a handful of bugs, improved load query efficiency, and fixed duplication and misplacement of reference mappings in project and …
Continue reading Announcing SSIS Catalog Browser v0.9.20

Potential Danger Using Deploy Package with SSIS 2016

I… tweeted? X’d?… this message 11 Jul 2024. As promised, here’s the public post. If you want to skip some history mixed with the description of EDNA’s SSIS framework, feel free to go to the section labeled “Imagine My Surprise…” Some Back Story I have a long and storied history with frameworks. My ETL frameworks …
Continue reading Potential Danger Using Deploy Package with SSIS 2016

Presenting A Day of Fabric Data Factory at SQL Saturday Pittsburgh

I’m honored to announce I am delivering A Day of Fabric Data Factory – a full-day of in-person pre-conference training at SQL Saturday Pittsburgh! The precon happens Friday, 11 Oct 2024; SQL Saturday Pittsburgh is Saturday, 12 Oct 2024. Abstract Do you want to learn more about cloud data integration using Fabric Data Factory? Is …
Continue reading Presenting A Day of Fabric Data Factory at SQL Saturday Pittsburgh

Announcing SSIS Premium Training

I’m excited to announce the availability of SSIS Premium, a training offering focused solely on SQL Server Integration Services (SSIS) recorded training. Learn more about each offered course at the following links: From Zero to SSIS – four days of recorded training, includes labs. Master the SSIS Catalog – a day of SSIS Catalog recorded …
Continue reading Announcing SSIS Premium Training

T-SQL Tuesday #176: What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?

July 2024’s T-SQL Tuesday is hosted by Dr. SQL himself, Louis Davidson. The topic is “What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?” I learn from my mistakes and I’ve learned plenty since my first data platform job! Defining “my …
Continue reading T-SQL Tuesday #176: What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?