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

Click to see the UK coverage of Microsoft Certification Courses from Activia

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
We'd like to discuss how we can give you the best service you will find.
Want to know more ?
Call us on 0845 230 6150
or click below to
Request a Callback

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 and 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
    [ Close ]

    Locations for Microsoft Certification Courses from Activia

    With our quality accreditations for ISO9001, IITT, ILM and the ILP, and a uniquely flexible service, you can be sure that your MCSA, MCTS and MCITP certification courses will get the results you need, at the prices you want.

    Activia centres for Microsoft MCSA MCTS & MCITP Certified Courses

    With seventeen fully equipped training centres , Activia should be your first choice for courses for Microsoft Certification wherever you are in the UK.
    We provide Microsoft MCSA MCTS & MCITP Certified Courses courses in the following locations:

    • London
      We have six centres in London, serving the City in Bank and Liverpool Street, and Canary Wharf from our London Bridge (SE1) centre, as well as North, West and South West London, in Finchley, Baker Street and London Victoria.
    • Surrey and Sussex
      Our Croydon centre serves Croydon, Reigate and Redhill as well as Crawley, Gatwick and Brighton.
    • Berkshire
      We serve Berkshire and the Thames Valley with three centres in Reading, Slough and Bracknell.
    • Bristol
      Covering Bristol, Avon, Bath and South West England
    • Milton Keynes
      Serving Buckinghamshire, covering Milton Keynes, Aylesbury and High Wycombe, as well as Luton and Bedford.
    • Birmingham
      Serving Warwickshire and the Midlands: Birmingham, Walsall and Dudley, as well as Wolverhampton, Solihull and Tamworth.
    • Nottingham
      Serving Nottingham, Long Eaton and Derby, as well as Loughborough, Melton Mowbray and Leicester.
    • Manchester
      Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.
    • Sheffield
      Serving South Yorkshire, covering Sheffield, Barnsley and Doncaster as well as Chesterfield and Wakefield.
    • Leeds
      Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.
    • Newcastle Upon Tyne
      Serving Tyneside, also Sunderland and Gateshead, as well as North Shields, South Shields and Whitley Bay.

    In House Microsoft Certification Courses from Activia across the UK

    For in house delivery of Microsoft MCSA MCTS & MCITP Certified Courses, you can expect the same standard of training and service for your MS Certification training classes as you get at our centres, conveniently delivered at your offices.
    To book your in-house certification courses for MCSA, MCTS and MCITP, you need look no further than Activia.

    Click for more about MS Certification training courses UK from Activia

    [ Close ]

    Quality Assurance