Laid Off? Or the Beginning of Your Next Opportunity?

Why not both? My LinkedIn and social media feeds are filled with contacts and friends sharing their availability for a new career opportunity. While some are more gracious than concerned and others more concerned than gracious, it’s normal to be both concerned and gracious. Well, it was normal for me when it happened to me. …
Continue reading Laid Off? Or the Beginning of Your Next Opportunity?

Azure-SSIS Express Custom Setup License Key Textbox Update

Back in June 2022, I was honored to deliver a webinar along with the good people on the SolarWinds Task Factory team. During that presentation, I noticed (and I may have even commented on) the License key textbox not being masked when adding Task Factory to an Azure-SSIS integration runtime. I sent a note to the …
Continue reading Azure-SSIS Express Custom Setup License Key Textbox Update

Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

I am honored to deliver Master the Fundamentals of ADF at SQL Saturday Boston 2022 (#1031) 7 Oct 2022! Abstract Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build fully managed ETL in the cloud – including SSIS. Join Andy Leonard – …
Continue reading Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

Join Me at the PASS Data Community Summit 2022!

I am honored to deliver two training sessions at the PASS Data Community Summit 2022: A Day of Azure Data Factory is a full-day pre-conference session scheduled for Monday, 14 Nov 2022. In this session I cover version control integration, copying data, using parameters and metadata, design patterns (of course!), and more! Introduction to Azure …
Continue reading Join Me at the PASS Data Community Summit 2022!

Azure-SSIS Supports SSIS 2017 Only

With the recent public preview release of Synapse-SSIS, I want to remind SSIS developers that Azure-SSIS integration runtimes – be they configured in Azure Data Factory (ADF) or in Azure Synapse Analytics – support only SSIS 2017 packages. Errors most often occur when executing SSIS packages that contain script tasks or script components. If you deploy …
Continue reading Azure-SSIS Supports SSIS 2017 Only

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework

My Black Friday 2020 Sale is On!

Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!

Azure-SSIS Catalog Database Connection Failed

I was provisioning a new Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR) to conduct some testing and, when I clicked the “Test connection” link, I got a Connection failed error as shown in the red box: I clicked the “More” link to display details in the blue box To provision new Integration Runtime, Azure …
Continue reading Azure-SSIS Catalog Database Connection Failed