In this geekSpeak, Microsoft Most Valuable Professional (MVP) Andy Leonard discusses best practices for using Microsoft SQL Server Integration Services (SSIS) in the enterprise. Andy explains what SSIS does well and doesn't do well and describes common
struggles when learning SSIS (expressions, configurations, externalization, dynamic properties, scripting). Other topics he'll cover include deployment, execution methods, security, and design patterns. This geekSpeak is hosted by Glen
and G. Andrew Duthie
The geekSpeak webcast series brings you industry experts in a "talk-radio" format hosted by developer evangelists from Microsoft. These experts share their knowledge and experience about a particular developer technology and are ready to answer your questions
in real time during the webcast.
Andy Leonard, Architect, Unisys Corporation
Andy Leonard is an architect with Unisys Corporation who blogs for SQLBlog.com. He is a Microsoft SQL Server and SQL Server Integration Services developer, SQL Server Most Valuable Professional (MVP), Professional Association of SQL Server (PASS) Regional Mentor
(Southeast U.S.), and engineer. Andy is also a coauthor of Professional SQL Server 2005 Integration Services (Wrox, 2006), Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers (Wrox, 2007), SQL
Server MVP Deep Dives (Manning, 2007), and MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005.
Andy's background includes Web application architecture and development; Microsoft Visual Basic and ASP; SQL Server Integration Services (SSIS); data warehouse development using Microsoft SQL Server 2000, SQL Server 2005, and SQL Server 2008; and test-driven