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
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