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

The Recording for Building an SSIS Framework in Azure Data Factory

Enjoy this recording of the (free!) Enterprise Data & Analytics webinar titled Building an SSIS Framework in ADF! :{> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work …
Continue reading The Recording for Building an SSIS Framework in Azure Data Factory

Free Webinar – Building an SSIS Framework in ADF

Join me at 12:00 PM EDT on 9 Jul 2020 for Building an SSIS Framework in ADF, another free Summer o’ ADF webinar from Enterprise Data & Analytics. Abstract Andy authors SSIS frameworks according to a few principles: 1. Functionality 2. Empathy 3. Simplicity Join Microsoft Data Platform MVP Andy Leonard as he discusses and …
Continue reading Free Webinar – Building an SSIS Framework in ADF

The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available

Enjoy this recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes! <ShamelessPlug> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. …
Continue reading The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available