Topic: Cool Stuff with SQL Server Integration Services
Speaker: Andy Leonard
Where: HCC Business Training Center, 6751 Columbia Gateway Drive, Columbia, MD 21046
When: Tuesday, July 1, 2008 from 6:30PM - 9:00PM
The CMAP website has information and directions to the meeting.
This presentation will cover some common questions about working with SSIS.
Topics include:
- Iterating and loading the Excel files in a directory - with no code!
- Parent Packages, Package Configurations, and Variables
- Deployment, and SSIS Application Lifecycle Management
- Optimizing Incremental Loads (time permitting)
- ETL Instrumentation and Custom Logging (time permitting)
Bio
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.