I am excited to announce I am finally ready to present my advanced ETL Framework with Biml seminar at SQL Saturday Charlotte on Oct 14. And I have a 10AM slot!!! Wooo! Implementing a SSIS Framework and enforcing SSIS Patterns (with Biml). (Using Biml to Automate the Implementation of a SSIS Framework) Let's use Biml … Continue reading SQL Saturday Charlotte 2017
BMI KeyNotes – Toastmasters Speech on Biml
As practice for delivering a 50-minute seminar to my fellow ETL Developers at BMI, I presented Speech 5 from the Toastmasters Technical Presentations manual. It was a whopping 12-15 minute speech and I didn't go over time!!! Yay!!! (I normally blow through the red card and end up a minute or two over my … Continue reading BMI KeyNotes – Toastmasters Speech on Biml
SQL Saturday Atlanta!
I am excited to announce that I will be giving my BIML seminar in Atlanta in July!!! Here's the abstract for my session: How to move a ton of data from the Mainframe to the Cloud (with Biml). So, you need to move data from 75 tables on the mainframe to new tables in SQL … Continue reading SQL Saturday Atlanta!
Yay!!! I'll be speaking about Biml at SQL Saturday in Chattanooga in June! I'm very excited. In typical fashion, I will probably cram too much into the hour, but I'll try not to. Here's the abstract for my session. Using Biml to Automate the Generation of SSIS Packages So, you need to move data from … Continue reading SQL Saturday!!!
Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator
Now that we can generate simple empty packages, the next step is to add connection managers to the project and package. After that, we will add a DataFlow. This article will focus on the Connections though, and we will start with a pair of standard OleDb Connections. Recall the metadata tables from the last article: … Continue reading Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator
Biml Tutorial 2 – Creating a Simple Package Generator
So I spent yesterday morning entering the metadata to describe some 70 or so packages that are all part of a big data load that moves data off the mainframe (DB2) into SQL Azure. Occasionally, I would build the packages with BIML Express to ensure I hadn't introduced bad metadata. Today, I tweaked the BIML to allow for … Continue reading Biml Tutorial 2 – Creating a Simple Package Generator
Biml Tutorial 1 – Introducing BIML
Intro to Automated Package and Template Generation with BIML In order to simplify and automate the template creation and package creation process, we will create a Proof-of-concept (POC) that uses the Business Intelligence Markup Language (BIML, pronounced bim-ul). BIML provides a language with which to generate SSIS packages using highly configurable metadata. Business Intelligence Markup … Continue reading Biml Tutorial 1 – Introducing BIML