Microsoft SQL Server 2008 Integration Services Business Intelligence Skills for MCTS 70-448 and MCITP 70-452 Video Mentor

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)