January 22 – Jack Corbett – It’s All about the Rules: A Dynamic ETL Architecture

Dates: 01/09/2018 - 01/23/2018 Dates: 01/09/2018 - 01/23/2018 Location: Roundabout Diner

Join us at the Roundabout Diner in Portsmouth (RSVP) for:

It’s All about the Rules: A Dynamic ETL Architecture
You are provided with requirements for an ETL Process that has hundreds of rules that need to be applied and you code them all and during testing some rules change and more are added requiring you to modify SSIS packages taking hours of your time and there is no simple method to isolate testing the changed and new rules costing even more time. In this session we will go over how we addressed this situation with a rules-based architecture, where rules are defined in a database and read and executed from SSIS.

About the Presenter

Jack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2016 and was a Microsoft MVP for SQL Server from October 2011 to October 2016. Jack has presented at many user groups and SQLSaturdays events.


6:00-6:30 – Networking & Appetizers provided by Alexander Technology Group
6:30-6:45 – Announcements
6:45-8:00 – Feature Presentation
8:00-9:00 – Discussion & Networking


No comments yet.

Leave a Reply