Platinum Sponsor

Designing an SSIS Framework

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Presented by Andy Leonard at SQLBits IX
  • Downloads
  • SpeakerBIO
    andy_leonard.jpg
    Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer and Consultant and developer, SQL Server database and data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005, 2008, and 2012.
    http://sqlblog.com/blogs/andy_leonard http://sqlblog.com/blogs/Opml.aspx
  • Video
  • Session Files Explorer
    The network name cannot be found.