Build a Get-Subscription ADF Pipeline Using Pipeline Return Value Course Now Available

I am excited to announce the availability of Build a Get-Subscription ADF Pipeline Using Pipeline Return Value, a new Azure QuickStart course! Access the new course – along with all my recorded training for one year – by subscribing to Premium Level. Additional access options include: Azure QuickStart Premium – Access all Azure QuickStart training …
Continue reading Build a Get-Subscription ADF Pipeline Using Pipeline Return Value Course Now Available

Presenting Introduction to ADF at Hampton Roads Azure Users Group at 6:00 PM 10 Oct 2023!

I am honored to present Introduction to ADF at Hampton Roads Azure Users Group at 6:00 PM 10 Oct 2023! I’ll be there live and in-person. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration …
Continue reading Presenting Introduction to ADF at Hampton Roads Azure Users Group at 6:00 PM 10 Oct 2023!

Return a Value from an ADF Pipeline Course Now Available

I am excited to announce the availability of Return a Value from an ADF Pipeline, a new Azure QuickStart course! Access the new course – along with all my recorded training for one year – by subscribing to Premium Level. Additional access options include: Azure QuickStart Premium – Access all Azure QuickStart training plus Premium …
Continue reading Return a Value from an ADF Pipeline Course Now Available

Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available

I am excited to announce the availability of Build a Pipeline to Stop an ADF Azure-SSIS IR, a new Azure QuickStart course! Access the new course – along with all my recorded training for one year – by subscribing to Premium Level. Additional access options include: Azure QuickStart Premium – Access all Azure QuickStart training …
Continue reading Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available

Failed Get Parameter Info Error in Azure-SSIS

Have you encountered this error: “Failed Get Parameter Info of parameter ____”? I ran into this error a couple times while consulting for a client to lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). The Most Likely Fix Make sure the Azure-SSIS integration runtime is running: Launch Azure Data Factory …
Continue reading Failed Get Parameter Info Error in Azure-SSIS

How to Get ADF to List Available Properties

Did you know Azure Data Factory (ADF) will actually list available properties? It will. One of the things I cover in my ADF training titled Master the Fundamentals of Azure Data Factory is this handy troubleshooting tip. An Error I am attempting to read the status of a pipeline execution using a call to the ADF …
Continue reading How to Get ADF to List Available Properties

ADF Activity State Property Disables Pipeline Activities

Update: Chenye Charlie Zhu has posted an excellent article about this new functionality over at the Microsoft ADF blog! It’s titled Comment Out Part of Pipeline. Part of one of my consulting gigs is helping a client lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). While developing some test pipelines …
Continue reading ADF Activity State Property Disables Pipeline Activities

ADF Pipeline Return Value Series

While delivering Azure Data factory (ADF) consulting for a client, I had the opportunity to develop some utility pipelines that used Pipeline return values functionality (in preview at the time of this writing). For me, this exercise was a two-step process, which I share in this series: One Simple Example of ADF Pipeline Return Value …
Continue reading ADF Pipeline Return Value Series

Presenting A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Analytics Edition

I am honored to present A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Data Analytics Edition (#1042) 24 Feb 2023! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: Editing ADF pipeline JSON Version control integration Copying data …
Continue reading Presenting A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Analytics Edition