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
Subscribe to my Newsletter
Sign up for my newsletter to be notified of new posts from me! You may subscribe to my newsletter – Engineer of Data – by visiting my Substack: or using the widget available from this blog:
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?
SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent
I’m reading Announcing SSMS 20.2 … and getting feedback for SSMS 21 by Erin Stellato (LinkedIn) on the SQL Server Blog and this fix caught my eye: SSIS and SQL Agent – many customers ran into a connection error (“The certificate chain was issued by an authority that is not trusted”) in SQL Agent when trying …
Continue reading SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent