SSIS Endures: A Bird's-Eye View to Hands-On Solution

The March Ohio North Database Training user group meeting will be held on April 1st, 2025 at 5:00PM. This will be a HYBRID event and we are working on a great data speaker for you.

You're welcome to come meet in-person at our usual meeting location at the Artemis offices at:

6161 Oak Tree Blvd, Ste 300
Independence, OH 44131

Agenda:

5:00 PM EST: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be pizza brought in for in-person attendees.

6:00 PM EST: Updates and announcements, followed by our feature presentation. See below for presentation details.

7:30 PM EST: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment.

We hope to see you there!

Session Abstract

Data integration can be a daunting challenge, but SQL Server Integration Services (SSIS) offers the tools to tackle even the most complex workflows. In this session, we’ll explore the architecture of SSIS, starting with the essentials of Control Flow and Data Flow, and the role of the SSISDB catalog in managing deployments. Beyond theory, we’ll dive into practical applications, from connectivity options and error handling to automation with SQL Server Agent.

The highlight of the session is a real showcasing of how key transformations like Conditional Split, Lookup, Merge Join, and Slowly Changing Dimensions come together in a cohesive process. You’ll see how SSIS can streamline data transformations and solve integration challenges while remaining scalable and efficient. By the end, you’ll have both the big-picture understanding and practical insights to bring SSIS solutions to life.

*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.