Baltimore-SQL-Business Intelligence Group

Next Meeting

Wednesday,

August

17

Regular Monthly Meeting

  • In-Person @ 10150 Old Columbia Road Columbia, Maryland, United States (map)
  • 18:00 - 20:30 UTC
  • Language: English

Regular Monthly Meeting

Featured Presentation:

BIML and SSIS Frameworks

Andy Leonard, Chief Data Engineer Enterprise Data & Analytics

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:
Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, 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 The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page. He may be followed on Twitter @AndyLeonard.

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids