The Azure-SSIS Team has done it again; they’ve added more cool SSIS execution functionality to Azure Data Factory! Execute SSIS Package Activity Update First, add an Execute SSIS Package Activity in an Azure Data Factory pipeline. On Settings, select an Azure-SSIS Integration Runtime. Set Package Location to “Embedded package”: The Execute SSIS Package activity’s properties …
Continue reading Embed an SSIS Package in an Azure Data Factory Pipeline
Category:SSIS
Wrapping up the Summer o’ ADF 2019
As the 2019 Summer o’ ADF 2019 draws to a close, we look forward to shorter and cooler Autumn days (in the northern hemisphere, at least!), conference season, and the fast-approaching holidays. As always, I had an absolute blast sharing tips and tricks for using Azure Data Factory in the enterprise. I must admit that …
Continue reading Wrapping up the Summer o’ ADF 2019
Overcome Challenges of Lifting and Shifting SSIS to Azure
Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure
Presenting Moving Data with ADF at TriPASS 20 Aug
I am honored to deliver Moving Data with ADF to the Triangle SQL Server Users Group (TriPASS) 20 Aug 2019 starting at 6:00 PM EDT! This event will be streamed live via Twitch. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical …
Continue reading Presenting Moving Data with ADF at TriPASS 20 Aug
Honored to Present From Zero to ADF at SQL Saturday Atlanta – BI Edition
I am honored to deliver my brand-spanking-new full day pre-conference titled From Zero to ADF at SQL Saturday Atlanta – BI Edition 18 Oct 2019! (It still has that new precon smell!) My precon will be delivered at:Microsoft Avalon8000 Avalon BoulevardSuite 900Alpharetta, GA 30009 Abstract From Zero to ADF is designed to jumpstart data engineering …
Continue reading Honored to Present From Zero to ADF at SQL Saturday Atlanta – BI Edition
Execute SSIS Package in Azure-SSIS
If you browse to an instance of an Azure Data Factory SSIS Integration Runtime – aka Azure-SSIS IR – you may notice an icon / button that appears as shown above. There are two ways to reach the Execute SSIS Package functionality, via the Monitor page and via the Author page’s Connections tab. From the …
Continue reading Execute SSIS Package in Azure-SSIS
SSIS Is Not Dead (Or Dying)
A few weeks ago I began hearing a rumor that SSIS had a couple years of life remaining. “In two years or so,” according to the rumor, “SSIS will die and be replaced with Azure Data Factory.” Is Microsoft capable of such a move; deprecating a technology? Yep. Remember SQL Server Notification Services? I can …
Continue reading SSIS Is Not Dead (Or Dying)
Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020
I am honored to co-present a full-day post-conference workshop – Intelligent Data Integration with SSIS and Azure Data Factory – with Sandy Winarko, Principal Program Manager at Microsoft – Azure Data Governance, Cloud & Artificial Intelligence (AI), at Difinity 2020 in New Zealand! Details Full Day Workshop Level: 300 Post-Conference: 20th of Feb 2020 This …
Continue reading Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020
Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!
I am honored to deliver Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019! Abstract Data Integration Lifecycle Management – or DILM – is challenging regardless of your chosen data integration platform. The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!
Execute SSIS Packages in Azure-SSIS from Visual Studio Recording
Enjoy the recording of this session! :{>