geekSpeak Recording - Inside SQL Server Integration Services with Andy Leonard

Download this episode

Download Video


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 Gordon 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.

Guest Presenter:
Andy Leonard, Architect, Unisys Corporation

Andy Leonard is an architect with Unisys Corporation who blogs for 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 database development.



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.