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.
(no tags)
- Downloads
- SpeakerBIO
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, SQLBlog.com blogger, and engineer. He is a co-author of
Professional SQL Server 2005 Integration Services and
SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.
- Video
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.