Computers & Internet Books:

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

Format

Mixed media product

Customer rating

Click to share your rating 0 ratings (0.0/5.0 average) Thanks for your vote!

Share this product

Microsoft SQL Server 2008 Integration Services Business Intelligence Skills for MCTS 70-448 and MCITP 70-452 Video Mentor by Wendy Henry
Unavailable
Sorry, this product is not currently available to order

Description



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)

Author Biography

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.
Release date Australia
April 13th, 2010
Author
Country of Publication
United States
Imprint
Que Corporation,U.S.
Pages
80
ISBN-13
9780789743183
Product ID
3907425

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here

Help & options

  • If you think we've made a mistake or omitted details, please send us your feedback. Send Feedback
  • If you have a question or problem with this product, visit our Help section. Get Help
Filed under...