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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
“It’s Past 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 Past 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!
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.
The Recording for Execute Azure-SSIS from Azure Files
The recording for the free Enterprise Data & Analytics webinar titled Execute Azure-SSIS from Azure Files is available here with no registration required. Enjoy! :{>
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
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
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