SQL Server 2005/2008 Integration Services (SSIS) Fundamentals

Course

In Gatwick

£ 1,150 + VAT

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    3 Days

As about 80% of this presentation is ETL based, upon its completion, the delegate should be able to think clearly with regards the available SSIS options and implement these options to meet a variety of extract, transform and load solutions in BI and non-BI environments. Suitable for: Business intelligence and data warehouse developers, ETL architects and DBAs.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

At least six (6) months experience with SQL Server 2000 or later. Experience of Visual Studio useful but not necessary.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Level: Beginner-to-intermediate Audience: Business intelligence and data warehouse developers, ETL architects, DBAs and system administrators. Prerequisites: At least six (6) months experience with SQL Server 7.0 or 2000 DTS. Summary: This presentation provides detailed treatment of the following SQL Server 2005 Integration Services (SSIS) topics:
  • Creating and managing SSIS packages
  • Connecting to, querying and transforming disparate data sources
  • Scripting
  • Business Intelligence and data warehousing considerations
  • Event handling
  • SSIS problem determination
  • And the like.
Objectives: Upon completion of this presentation, the participant should be able to use the SQL Server 2005 toolset to deploy a broad range of SSIS requirements per the 'Core Topics' in the detailed outline. Format: Lecture and hands-on (about 70%).

SQL Server 2005/2008 Integration Services (SSIS) Fundamentals

£ 1,150 + VAT