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

“It’s 10 July 2019 and We Still Have SSIS 2008 in Production…”

I am writing this post 10 Jul 2019. Yesterday, support ended for SQL Server 2008 and 2008 R2. Many are still running SQL Server 2008 and 2008 R2 in production, and many are using SSIS 2008 and 2008 R2 in production as well. If you are reading this post and thinking or saying, “Yep. He’s …
Continue reading “It’s 10 July 2019 and We Still Have SSIS 2008 in Production…”

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.

Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters

UPDATE: You may view the recording of this webinar at Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording. Enjoy! :{> Join me 8 Jul 2019 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar titled Azure Data Factory, Azure-SSIS, and Pipeline Parameters! In this free webinar, we build on the demonstration from …
Continue reading Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters

The Recording for Designing a Basic SSIS Execution Framework

As will sometimes happen when one chooses to type in demos, things went awry in the last demo. I choose to type in demos because I don’t want to create the false impression that SSIS Just Works the first time, every time. After the webinar ended I spent some time troubleshooting. The issue appears related …
Continue reading The Recording for Designing a Basic SSIS Execution Framework

Free Webinar: Designing a Basic SSIS Execution Framework

Join me at 12:00 PM EDT 27 Jun 2019 for Designing a Basic SSIS Execution Framework – another free webinar from Enterprise Data & Analytics! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 60 minutes packed with demos of how to design a basic SSIS Execution Framework to centralize and simplify SSIS …
Continue reading Free Webinar: Designing a Basic SSIS Execution Framework

HowTo: Install SSIS Framework Community Edition

SSIS Framework Comunity Edition is available from DILM Suite (Data Integration Lifecycle Management Suite). SSIS Framework CE is not only free, it is open source. To install SSIS Framework Community Edition, visit DILM Suite and click SSIS Framework Community Edition: When the SSIS Framework Community Edition page opens, click the first link: This link will …
Continue reading HowTo: Install SSIS Framework Community Edition

New SSIS Catalog Browser Azure Properties

Thanks to some help from my friend, Sandy Winarko, SSIS Catalog Browser version 0.8.9.0 now includes Azure-SSIS Catalog Properties for Azure Worker Agents and Azure Status. When Azure-SSIS is stopped or starting, SSIS Catalog Browser reports an Azure Status of “Not Running”: Once even one Azure-SSIS worker agent starts, SSIS Catalog Browser reports an Azure …
Continue reading New SSIS Catalog Browser Azure Properties

The Recording for Loading Medical Data with SSIS is Available

Kent Bradshaw and I had a blast delivering Loading Medical Data with SSIS earlier today! If you missed the webinar and, perhaps more importanly, coupon codes to save on upcoming Enterprise Data & Analytics Training. Enjoy the video! We demonstrated a handful of (free!) DILM Suite (Data Integration Lifecycle Management) utilities: Catalog Reports SSIS Catalog …
Continue reading The Recording for Loading Medical Data with SSIS is Available

Free Webinar – Enterprise SSIS Execution

Join Kent Bradshaw and me as we present (another) free Enterprise Data & Analytics webinar Tuesday, 23 Apr 2019 at 12:00 PM EDT: Enterprise SSIS Execution. Abstract SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join Andy Leonard – Microsoft Data platform MVP, author, …
Continue reading Free Webinar – Enterprise SSIS Execution