Install and Configure SSIS Framework File Community Edition

I recently released SSIS Framework File Community Edition. In this video, I walk through obtaining the code and deploying the components of this free and open-source solution. You can obtain the code at github.com/aleonard763/SSIS-Framework-File-Community-Edition. Note: I tried some new settings in OBS Studio. Let me know what you think! Enjoy! :{>

LinkedIn Poll: Where Are Your SSIS Packages Stored?

I conducted a poll on LinkedIn 7 Jan 2022: If you use SSIS in your enterprise, where are SSIS packages stored? The results are in: With 250 votes cast, the results read: 78% use the SSIS Catalog 12% use the File System 10% use MSDB Thanks to everyone who participated! :{>

Announcing SSIS Framework Community Edition 2022

I am honored to announce the latest addition to DILM Suite, another free and open-source project named SSIS Framework Community Edition 2022! SSIS Framework CE 2022 is an updated version of SSIS Framework Community Edition – which is also free and open-source – but features a separate database, named SSISFrameworkDB,  for storing SSIS Application and Package …
Continue reading Announcing SSIS Framework Community Edition 2022

SSIS Catalog Reports – Operations Report

I recently added an Operations Report to DILM Suite‘s SSIS Catalog Reports solution. To acquire your very own copy of SSIS Catalog Reports – a free and open-source SQL Server Reporting Services (SSRS) solution – visit DILM Suite: Scroll until you find the link to SSIS Catalog Reports, and then click the link: The new …
Continue reading SSIS Catalog Reports – Operations Report

Documenting an SSIS Lift and Shift Project

I was honored to work on a cool SSIS lift and shift project in 2021. I will not mention project details or the client. I will share that I’ve worked with the team before and that they are awesome and talented and easy to work for (and with). The company is large. Like international-large. I, …
Continue reading Documenting an SSIS Lift and Shift Project

AndyStream for 7 Nov 2021

Frank and I are on Day 5 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – systems of execution. This morning I popped on for a few minutes to (again) share information about Enterprise Data & Analytics‘ …
Continue reading AndyStream for 7 Nov 2021

AndyStream for 6 Nov 2021

Frank and I are on Day 4 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – systems of execution. This morning I popped on for a few minutes to shared information about Enterprise Data & Analytics‘ commercial …
Continue reading AndyStream for 6 Nov 2021

New SSIS Extension v3.15 for Visual Studio 2019

On 16 Aug 2021, the Microsoft SSIS Team released version 3.15 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning.   I am late getting this update published. Visual Studio 2019 v16.11.4 is now available… …
Continue reading New SSIS Extension v3.15 for Visual Studio 2019

Video Coding and Loading Leonard Greenhouse Data

I had some time over the weekend to work on a process to capture weather measurements from an IoT instrument pack Stevie Ray recently constructed. You can learn more about what he did over at his blog – StephenRayLeonard.com – in a post titled The Modern Back Yard Greenhouse Begins With IoT. Although I did …
Continue reading Video Coding and Loading Leonard Greenhouse Data