SSIS Is Not Dead

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

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!

Regarding SSIS Training…

This post was inspired by an email I recently sent to a prospective student of the Enterprise Data & Analytics training course titled From Zero to SSIS. The student asked very good questions about the value of training for certification vs. the value of training to gain knowledge. Both types of training are important; both …
Continue reading Regarding SSIS Training…

Updated: SSIS Catalog Logging and Reporting in the Enterprise

The SSIS Catalog, first introduced with the release of SQL Server 2012 Integration Services (SSIS 2012), is a big step forward in Data Integration Lifecycle Management (DILM) with SQL Server Integration Services (SSIS). Like all software, the SSIS Catalog performs some tasks admirably and other tasks… not so admirably. In this post, I will share …
Continue reading Updated: SSIS Catalog Logging and Reporting in the Enterprise

“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…”

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

Delivering Moving Data with Azure Data Factory to the Augusta SQL Server and BI User Group!

I am honored to deliver Moving Data with Azure Data Factory to the Augusta SQL Server and BI User Group 7 Aug 2019 starting at 5:30 PM EDT! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the …
Continue reading Delivering Moving Data with Azure Data Factory to the Augusta SQL Server and BI User Group!