Course code: MOC 2792« Back

Microsoft SQL Server 2005 – Integration Services – Implementing and Maintaining

This three-day course is intended for developers and database system administrators and teaches participants about a totally new ETL tool available in SQL Server 2005.

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 18 450 CZK included in course price 30
Brno3 18 450 CZK included in course price 30
Bratislava3 525,00 EUR 189,00 EUR 30

Who is the course for

This three-day course is intended for developers and database system administrators

What we teach you

  • You will explore the uses and architecture of SSIS packages
  • You will learn how to work with Control Flow
  • You will learn how to work with Data Flow
  • You will learn how to use the advanced package options such as variables, activity logging and error capture
  • You will learn how to configure and deploy packages
  • You will learn how to administer SSIS packages

    Required skills

  • Familiarity with the principles of relations databases
  • Knowledge of SQL language
  • Familiarity with object-oriented programming and .NET architecture

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    Books published by specialist publishers.

    Course Outline

    Overview of SSIS

    • Typical uses
    • SSIS architecture
    • Tools and utilities in SSIS

    SSIS packages

    • Development environment
    • SSIS solutions and projects
    • Concept and structure of SSIS packages

    Working with Control Flow

    • Containers
    • Tasks
    • Flow control

    Working with Data Flow

    • Data sources
    • Transformations
    • Data destinations

    Advanced features of packages

    • Using variables
    • Activity logging
    • Error handling
    • Transaction processing

    Deploying packages

    • Configuring packages
    • Deploying packages
    • Package security

    SSIS administration

    • SSIS services administration
    • SSIS packages administration
    • Activity monitoring

    SSIS programming

    • Programmatic packages building
    • Programmatic packages saving and validation
    • Programmatic packages execution

    Previous courses

    no preceding courses

    Next courses

    no following course
    Tištěná příručka MOC 2792

    Price:
    4950 CZK
    Tištěná příručka MOC 2792

    Price:
    189 EUR
    The prices are without VAT.