Course Details

Previous Page


Configuring SQL Server 2008 Integration Services Packages


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks that provide the package functionality, and precedence constraints that define the interconnection between tasks to create the control flow. For package data flow, the elements covered are the sources used to extract the data, transformations used to manipulate the data, and destinations responsible for loading the data. Paths are then used to connect the components to form the data flow. The course also covers Integration Services features that can be used to extend the functionality of packages, including event handlers, transactions, checkpoints, variables, expressions, and queries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer

Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration (hours)
2.0

Lesson Objectives

Configuring SQL Server 2008 Integration Services Packages

  • recognize how the connection manager works
  • recognize how to work with control flows
  • recognize how event handlers and Integration Services variables are used in SQL Server 2008
  • recognize how to use Property Expressions in SQL Server 2008
  • use checkpoints and transactions in SQL Server 2008
  • recognize how to implement control flow
  • recognize how to implement data flow
  • create an SSIS solution
  • create an SSIS data package flow
  • Course Number:
    md_mqbm_a02_it_enus