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

Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available

I am excited to announce the availability of Deploy an SSIS Project to 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 Deploy an SSIS Project to an ADF Azure-SSIS IR 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

TaskFactory Activation Error in Azure-SSIS

I regularly help customers migrate SSIS to Azure-SSIS integration runtimes, a nifty component of Azure Data Factory. I was recently stumped by an error activating TaskFactory (Task Factory for the search engines…) on an Azure-SSIS IR node. The error was: “The system cannot find the file specified.” The TaskFactory activation file is named PragmaticWorks.TaskFactory.Licensing.exe. The …
Continue reading TaskFactory Activation Error in Azure-SSIS

SQL Feedback

Update: Erin Stellato [LinkedIn], program manager extraordinaire,  responded to my off-topic comment (that inspired this post): Thanks, Erin! If you would like to suggest or view other suggested changes to a Microsoft product or platform, head over to the page labeled Microsoft Azure | Share your Ideas. I have to warn you to not get …
Continue reading SQL Feedback

Andy’s Generative AI Poll

Last week I posted polls on Twitter and LinkedIn asking readers the following question: The answer to my poll question – at the time* – was “None”. *”At the Time, Andy?” Yep. I finally broke down and used ChatGPT – to which I subscribe – to help in the blog post before this one: Why …
Continue reading Andy’s Generative AI Poll

Why I Have Never Liked Personas

First, A Story Years ago I managed an ETL Team at Unisys. When I became manager, we had about 24 team members. The team grew to 40 members. I was initially hired to build an SSIS framework to replace functionality built-in to a competing product. The maintenance cost for the competing product was $1,000,000USD per …
Continue reading Why I Have Never Liked Personas

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