[SSIG] Biml and SSIS Frameworks with Andy Leonard
Event Information
Description
6:00 – 6:30 Pizza and Networking sponsored by Find Great People
6:30 – 6:40 Announcements
6:40 – 7:00 Andy Schwabe: A Powershell Primer
7:00 – 8:15 Andy Leonard : Biml and SSIS Frameworks
8:15 – 8:30 Closing remarks and give-a-ways
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 Andy Leonard:Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.
