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

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

Free Webinar: Execute SSIS Packages in Azure-SSIS from Visual Studio

Join me 15 Jul 2019 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar titled Execute SSIS Packages in Azure-SSIS from Visual Studio! Abstract Join Microsoft Data Platform MVP Andy Leonard for this free webinar to learn more about the Visual Studio Extension for Integration Services 3.1, which allows SSIS developers to …
Continue reading Free Webinar: Execute SSIS Packages in Azure-SSIS from Visual Studio

Azure-Enabled SSIS Projects

The Azure-SSIS Team recently released an update to the Integration Services Extension. The update includes a new project template named “Integration Services Project (Azure-Enabled)”. The functionality is driven by another recent addition to Azure-SSIS; the ability to execute SSIS packages from Azure File Shares. I refer to this as “Azure-SSIS (Files)”. I’ve written and presented …
Continue reading Azure-Enabled SSIS Projects

Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording

Enjoy the recording of the free Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording! Another free webinar presented by Enterprise Data & Analytics as part of the Summer O’ ADF 2019.

How To: Execute Azure-SSIS Packages From Azure Files

UPDATE: View the recording of the free webinar titled Execute Azure-SSIS from Azure Files. Enjoy! :{> Join me Tuesday, 2 Jul 2019 at 12:00 PM EDT for a free webinar titled Execute Azure-SSIS Packages from Azure Files! An Updated Azure-SSIS Integration Runtime I confess: I have been waiting for this feature since I first learned …
Continue reading How To: Execute Azure-SSIS Packages From Azure Files

Free Webinar: Using the Azure Data Factory If Condition and Web Activities

The summer o’ ADF continues with another free webinar from Enterprise Data & Analytics Friday, 14 Jun 2019 at 12:00 PM EDT: Using the Azure Data Factory If Condition and Web Activities! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 30 minutes packed with demos. In this session, Andy walks through using …
Continue reading Free Webinar: Using the Azure Data Factory If Condition and Web Activities