Andy Leonard: BIML and SSIS Frameworks

You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. You’ve heard that with Biml you can create a lot of SSIS packages in very little time. You follow this advice and end up with dozens of SSIS packages. Now what? A metadata-driven SSIS Execution Framework will simplify the execution of several SSIS packages down to a simple, one-line stored procedure call. But then, how does one manage all the metadata required to populate the SSIS Execution Framework? Biml to the rescue!

About the Speaker:

Andy Leonard is a Data Philosopher at Enterprise Data & Analytics (http://entdna.com/), an SSIS Trainer, Consultant (http://andyleonard.net/), and developer; a Business Intelligence Markup Language (Biml) (http://varigence.com/biml) developer and BimlHero (https://varigence.com/Blog/Post/65); SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns (http://smile.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837), and author of Managing Geeks - A Journey of Leading by Doing (http://smile.amazon.com/Managing-Geeks-Journey-Leading-Doing/dp/1502947609), and the Stairway to Integration Services (http://www.sqlservercentral.com/stairway/72494/).

Agenda

We are gathering at 6:00 P.M., Socializing until 6:30 P.M.

At 6:30 P.M. is official part: News, Announcements. Sponsors' Adds, organizational Questions.

Main Presentation at 7:00 P.M.