‘Twas the Saturday before the PASS Summit 2019 and all through Andy’s office… During my Azure DevOps and the SSIS Development Lifecycle presentation I may have an opportunity to demonstrate some DILM Suite applications: SSIS Catalog Browser, SSIS Framework Community Edition, SSIS Framework Browser, and Catalog Reports. All four applications are free. SSIS Framework Community …
Continue reading DILM Suite Applications
Category:DILM Suite
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
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)
“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…”
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 Community 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