Skip to content

BIML-UP! How I use BIML to speed up SSIS development

Photo of Mark Broadbent
Hosted By
Mark B. and Mikael W.
BIML-UP! How I use BIML to speed up SSIS development

Details

Updating SSIS packages can be tedious and error-prone. Let me show you how I use BIML and Excel to dramatically speed things up.

SSIS is a great product, but making changes to many packages takes a thousand clicks and you're more than likely going to make some mistakes.

In this session I'll show you how I've changed my SSIS development methodology to use BIML, C# and Excel to create a metadata-driven environment that eliminates repetitive tasks and dramatically speeds up the time it takes to create, change or recreate SSIS packages.

We'll cover some BIML basics as a starting point, work our way up to what a source-to-target mapping document is and how it's used in Data Warehouse projects, and hit our stride by bringing these two together in a beautiful and effective manner. It's time to BIML-UP!

Speaker Details:
Martin Schoombee is Chief Data Wrangler at 28twelve consulting he helps people make sense of their data, using Microsoft technologies.

Photo of Hybrid Virtual Group group
Hybrid Virtual Group
See more events