BIML-UP! How I use BIML to speed up SSIS development
Links:
Sign up to our Meetup group https://www.meetup.com/hybrid-virtual...
Join our LinkedIn group / 12487. .
Follow us on Twitter / hybridvug
...and of course don't forget to subscribe to our channel, like the video, and hit the bell! It really helps us in our mission to produce free content for the masses.
Session 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 Bio:
Martin Schoombee is Chief Data Wrangler at 28twelve consulting he helps people make sense of their data, using Microsoft technologies.
Host/s:
Mark Broadbent.
Mikael Wedham.
Originally recorded on 1st December 2021.
Video Production: Mark Broadbent 6th February 2022.
00:00 Introduction
01:45 What is Biml?
08:00 Reasons to use Biml
11:03 Biml basics (with Demo 1)
27:54 How I use Biml (with Demo 2)
49:48 Questions