Activia for 6235a: Sql Server 2008: Integration Services
speedy course quote from Activia Training
Bookings and Enquiries:                   0845 230 6150
Customer Service:                            0845 230 6159
We're here to help!     Click for a  FREE CALLBACK

Microsoft Certification Courses From Activia

MS SQL Server 2008 Integration Services SUPERCEDED

A Three-Day Training Course

Your training is easier with Activia because we have:
  • Recognised national quality accreditations
  • Training businesses since 1995
  • Friendly, capable, flexible service
  • Dedicated training advisors
  • Unique tools and backup
  • Fiercely competitive prices !
  Microsoft Certification Courses from Activia
Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Course Content

Authorised Microsoft Training Course

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.

Course Aims

Elements of this syllabus are subject to change. This three-day instructor-led 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.

Who Should Attend

This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.
Before attending this course, delegates must have:

  • Exposure to enterprise data import and export scenarios
  • Experience navigating the Microsoft Windows Server environment
  • Experience with Microsoft SQL Server, including
  • SQL Server Agent
  • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
  • SQL Server System tables
  • SQL Server accounts (users and permissions)
  • Course Outline

    Module 1: Introduction to SQL Server 2008 Integration Services
    • Overview of SQL Server Integration Services  • Using Integration Services Tools 
    Lab : Introduction to SQL Server Integration Services
    • (Level 200) Using the Import and Export Wizard  • (Level 200) Running an Integration Services Package 
    Module 2: Developing Integration Services Solutions
    • Creating an Integration Services Solution  • Using Variables  • Building and Running a Solution 
    Lab : Developing Integration Services Solutions
    • (Level 200) Creating an Integration Services Project  • (Level 200) Implementing a Package  • (Level 200) Building and Running an Integration Services package 
    Module 3: Implementing Control Flow
    • Control Flow Tasks  • Control Flow Precedent Constraints  • Control Flow Containers 
    Lab : Implementing Control Flow
    • (Level 200) Creating a Simple Control Flow  • (Level 200) Configuring Precedence Constraints  • (Level 200) Using Containers 
    Module 4: Implementing Data Flow
    • Data Flow Sources and Destinations  • Basic Data Flow Transformations  • Advanced Data Flow Transformations  • Data Flow Paths 
    Lab : Implementing Data Flow
    • (Level 200) Transferring Data  • (Level 200) Implementing Transformations  • (Level 200) Using Data Viewers  • (Level 200) Configuring Error Output 
    Module 5: Implementing Logging
    • Overview of Integration Services Logging  • Enabling and Configuring Logging 
    Lab : Implementing Logging
    • (Level 200) Configuring Logging  • (Level 200) Implementing Custom Logging 
    Module 6: Debugging and Error Handling
    • Debugging a Package  • Implementing Error Handling 
    Lab : Debugging and Error Handling
    • (Level 300) Debugging a Package  • (Level 300) Implementing Error Handling  • (Level 300) Controlling Failure Behavior 
    Module 7: Implementing Checkpoints and Transactions
    • Implementing Checkpoints  • Implementing Transactions 
    Lab : Implementing Checkpoints and Transactions
    • (Level 200) Implementing Checkpoints in a Package  • (Level 300) Implementing Transactions in a Package  • (Level 300) Implementing a Native Transaction 
    Module 8: Configuring and Deploying Packages
    • Package Configurations  • Deploying Packages 
    Lab : Configuring and Deploying Packages
    • (Level 200) Creating a Package Configuration  • (Level 200) Preparing a Package for Deployment  • (Level 200) Deploying a Package 
    Module 9: Managing and Securing Packages
    • Managing Packages  • Securing Packages 
    Lab : Managing and Securing Packages
    • (Level 200) Importing a Package  • (Level 200) Configuring and Monitoring a Package  • (Level 200) Scheduling a Package  • (Level 200) Securing a Package 

    Course Objectives

    After completing this course, delegates will be able to:

  • Describe SQL Server Integration Services and its tools
  • Create an Integration Services package
  • Implement control flow in an Integration Services package
  • Implement data flow in an Integration Services package
  • Implement logging in an Integration Services package
  • Debug and implement error handling in an Integration Services package
  • Implement checkpoints and transactions in an Integration Services package
  • Deploy an Integration Services package
  • Manage and secure an Integration Services package
  • Certification

    Microsoft Course 6235A

    More Information

    Prices for
    Printer-friendly course outline for MS SQL Server 2008 Integration Services SUPERCEDED

    Related Courses

    We also run the following related courses which may be of interest to you.
    Click for full details of content, prices & dates:

    Contact Us

    Activia Training
    Head Office:
    Regus House, 268 Bath Road
    Slough,   SL1 4DX

    Sales:       0845 230 6150
    Service:    0845 230 6159
    Accounts: 0845 230 6157

    Microsoft Certification Courses from Activia from Activia

    We can provide courses for Microsoft Certification at any of our seventeen centres UK wide, or we can come to your offices.
    We have been training since 1995 with a philosophy of high quality, flexible and cost effective provision, so you can be confident that we have the expertise, and the experience, to give all you need with MS Certification training classes.
    Call us now on 0845 230 6150 or request a free callback.

    Quality Assurance