Table of Contents
I. Implementing and Managing SQL Server 2008 Integration Services a. Lab 1: Install and Configure SSIS i. Pre-Installation Checklist (min req's, editions, etc.) ii. Install SSIS in non-clustered environment iii. Configuring Storage and Security b. Lab 2: Deploy SSIS Packages with Configuration Settings i. Managing SSIS Package Configurations (Package Configuration Wiz, Package Config. Organizer) ii. Editing SSIS Package Configurations (variables, connection managers) iii. Deploying SSIS Packages (file vs database, creating a package deployment utility) c. Lab 3: Execute SSIS Packages i. Managing SSIS Package Execution (logging, properties, DTUtil.exe) ii. Running SSIS Packages (dtexec.exe, DTExecUI.exe, SSIS Service, scheduling) d. Lab 4: Implement Security on SSIS Packages i. Using Digital Signatures (certificates, how-to sign a package) ii. Securing Package Contents (protection-level options, passwords) iii. Using MSDB Database Roles (examine roles and authority, add members) II. Developing Business Intelligence Solutions by Using SQL Server 2008 Integration Services a. Lab 1 Create and Debug Packages i. Creating a Package (BIDS, Import/Export Wiz, Package Migration Wiz) ii. Debugging Packages (progress reports, debug windows, breakpoints) b. Lab 2: Create Package Objects i. Creating Control Flow Using the Control Flow Designer (containers, tasks, precedence constraints) ii. Defining Control Flow Task Execution (transaction handling, checkpoints) iii. Creating Data Flow Using the Data Flow Designer (sources, destinations, constraints, decode strategy, transformation tasks, fast load vs incremental load) c. Lab 3: Implement Error Control i. Designing a Logging Strategy (identifying logging options, defining appropriate logging level ) ii. Designing an Event Handling Strategy (identifying appropriate placement of event handlers and checkpoints, defining appropriate use of data flow error control) iii. Create Event Handlers (identify trigger events, specify handler actions) iv. Implement Error Handling (control flow paths, data flow paths)
A Microsoft Certified Trainer (MCT) since 1998, Wendy Henry has been an independent technical trainer, author, and consultant for the last 10 years, specializing in Microsoft's SharePoint and SQL Server products since 2005. Her technical certifications include (Microsoft) MCP, MCDST, MCSA, MCSE, MCDBA, MCTS, MCITP, MCT; (Novell) CNE, CNI; (Cisco) CUSE, CCNA; (CompTIA) A+, Net+, Server+. Since 1998 Wendy has consulted on large enterprise projects for both industry and government.