Please join us as one of our favorite, longtime friends, Andy Leonard, SQL Server author, returns to share his immense SQL knowledge with us. The meeting will be the usual date, July 18th at 6:30 pm at Infotec. Please click here to register if you plan on attending.
Using BIML as an SSIS Design Patterns Engine (Level 300)
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
Objectives:
1. Demonstrate how to generate multiple SSIS incremental load packages with a single click.
2. Demonstrate the power of repeatable patterns-based development.
3. Demonstrate the flexibility Biml brings to data integration development.
Bio
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.