Training in MSSQL Server 2005: Implementing and Maintaining SQL Server 2005 Integration Services

In this program, students will study the below enumerated lessons:

Lesson 1: Preface of Structured Query Language Server 2005 Integration Services

This lesson explains the function that Integration Services performs in extraction, transformation, & loading of information. This lesson further explains the instruments, which one can utilize to create & administer Integration Services solutions.
* Summary of Integration Services Solutions
* Integration Services Instruments

Lesson 2: Expansion of I.S.S.

This lesson offers an outline of the growth functions that are included in building an Integration Services package. After completion of this lesson, students will be capable in creating a fundamental package.
* Building of an I.S.S.
* Variables Usage
* Creation & Administration of a Solution

Lesson 3: Control Flow Implementation

This lesson explains the functions & preference Restraints which one can bring into practice to apply control flow in an I.S.P..
* Control Flow Functions
* Control Flow Preference Restraints
* Control Flow Containers

Lesson 4: Information Flow Implementation

This lesson enumerates the information flow sources, Conversions, and Targets which one can utilize to execute an information flow function in an Integration Services control flow. It further enumerates the process of using information route to guide suitable & unacceptable rows throughout the information flow.
* Information Flow Sources & Targets
* Information Flow Conversions
* Information Flow Routes

Lesson 5: Implementing Logging

This lesson talks about the usage of logging in an I.S.P., & enumerates the process of configuring & using logging suppliers for generating data regarding package's implementation
* Summary of Integration Services Logging
* Logging Implementation

Lesson 6: Debugging & Mistakes Management

This lesson describes about debugging Integration Services package by utilizing the debugging instruments in Commercial Intelligence Development Studio. It further describes the ways of mistakes-control logic implementation in an Integration Services package.
* Package Debugging
* Mistakes Management Implementation

Lesson 7: Checkpoints & Proceedings Implementations

This lesson enumerates the nature of checkpoints & their implementation. It further talks about Proceedings, & enumerates the process with which one can apply transactional information access reason in an Integration Services package.
* Checkpoints Implementations
* Proceedings Implementations

Lesson 8: Packages Deployment

This lesson talks about the process of creating Package arrangements & the deployment of Integration Services packages to production server.
* Configuring Package
* Packages Deployment

Lesson 9: Management & Security of Packages

* This lesson enumerates the managerial functions that are relevant to Integration Service packages & describes the process of performing those functions by utilizing the Integration Services management instruments. It also enumerates the ways of securing Integration Services packages.
* Packages Management
* Packages Security