NewEra Technology Facebook
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services-Virtual Led - Course Information
PRINT
SEND TO A FRIEND
Name: 6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services-Virtual Led
Category: Microsoft Official Curriculum Courses
Length (Days): 3
Course Price (CAD): 1650
Description:
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
Prerequisites:
•6231 Maintaining a Microsoft SQL Server 2008 R2 Database
•6232 Implementing a Microsoft SQL Server 2008 R2 Database
Outline:
Lesson 1 - Introduction to SQL Server 2008 Integration Services
◦Overview of SQL Server Integration Services
◦Using Integration Services Tools

Lesson 2 - : Developing Integration Services Solutions
◦Creating an Integration Services Solution
◦Using Variables
◦Building and Running a Solution

Lesson 3 - Implementing Control Flow
◦Control Flow Tasks
◦Control Flow Precedent Constraints
◦Control Flow Containers

Lesson 4 - Implementing Data Flow
◦Data Flow Sources and Destinations
◦Basic Data Flow Transformations
◦Advanced Data Flow Transformations
◦Data Flow Paths

Lesson 5 - Implementing Logging
◦Overview of Integration Services Logging
◦Using Logging

Lesson 6 - Debugging and Error Handling
◦Debugging a Package
◦Implementing Error Handling

Lesson 7 - Implementing Checkpoints and Transactions
◦Implementing Checkpoints
◦Implementing Transactions

Lesson 8 - Configuring and Deploying Packages
◦Package Configurations
◦Preparing and Deploying Packages

Lesson 9 - Managing and Securing Packages
◦Managing Packages
◦Securing Packages
Guaranteed to run courses