Announcing SSIS Framework File Community Edition

The very first data integration / data engineering framework I ever wrote was for Data Transformation Services, or DTS. The DTS framework had one job: manage connections. I don’t recall all the details, but I remember DTS included a task that allowed packages to retrieve settings from INI files. INI files are key-value files, so …
Continue reading Announcing SSIS Framework File Community Edition

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

Expert SSIS Training, Live and Online 17-18 Jan 2022

I am excited to announce the next live and online delivery of Expert SSIS is 17-18 Jan 2022! Use the coupon code LimitedTimeDiscountExpertSSIS and save! Course Description Data integration is the foundation of data science, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals responsible for …
Continue reading Expert SSIS Training, Live and Online 17-18 Jan 2022