On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your SSIS packages from scratch. In this webinar, I’ll introduce the Biml language and its concepts and show you how you can generate multiple SSIS packages using metadata.
The abstract:
Working on your 20th staging package? Do you need to import 30 different flat files? Don’t have the time to create all those packages?
With Biml – Business Intelligence Markup Language – you can cut back on development time by:
- Generating your SSIS packages and database object using metadata.
- Turning tedious, repetitive work into reusable scripts.
- Automating general ETL patterns.
In this webinar, learn the basics of Biml and BimlScript and how we can use metadata to create a framework for automating your data integration tasks. After this webcast, you can start with the automation of your SSIS packages.
A working knowledge of Integration Services package development is necessary for this webcast.
You can register for the webcast here. And it’s free of course. At a later point in time (TBD), I’ll follow up with another webinar with more advanced topics.
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…