Cool Stuff With SQL Server Integration Services
By: Andy Leonard

In this presentation some common questions about working with SSIS will be covered. Topics include:

1. Iterating and loading the Excel files in a directory - with no code!
2. Parent Packages, Package Configurations, and Variables
3. Deployment, and SSIS Application Lifecycle Management
4. Optimizing Incremental Loads (time permitting)
5. ETL Instrumentation and Custom Logging (time permitting)

About Andy Leonard - Andy Leonard is a Solid Quality Mentor, SQL Server database and Integration Services developer, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services, Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers, MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005, and the recently-released e-book Mastering Visual Studio Team System Database Edition - Volume 1. Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence. He also blogs for SQLBlog.com. Andy's background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000 and 2005; and test-driven database development.