Introduction
In many daily database tasks, as well as in preparing data for reporting or
analysis tasks, moving data between different sources, combining, and cleaning
data are important tasks. In this course, we learn to use the Extract, Transform
and Load tool of SQL Server, Integration Services. This product is the
replacement for the former Data Transformation Services. It allows to load,
transform and write data from any OleDb or ODBC data source, and includes
support for XML, Web Services, WMI et cetera. Besides this, it has an excellent
integration with the .NET framework.
At Course Completion
Student will be able to create and manage Integration Services packages,
create Control flows and Data Flows, debug these packages, setup logging and
event handling for packages, configure package values with configuration files,
work with variables, and program ad hoc control and data flow tasks.
Prerequisites
Students taking this course should have a basic knowledge of the SQL query
language.
The course materials, lectures, and activities are in English. To benefit
fully from the instruction, students need an understanding of the English
language and completion of the prerequisites.
Course Outline
Module 1: Introduction
- The need for Integration Services
- Business Intelligence in SQL Server
- Business Intelligence Development Studio
Module 2: Designing Control flows
- Overview of tasks
- Precedence constraints
- Containers and loops
Module 3: Designing Data Flow
- Data Sources
- Data Transformations
- Data Destinations
Module 4: Debugging packages
- Setting breakpoints in Control Flow Tasks
- Adding data viewers to data streams
- Setup package logging
Module 5: Advanced package settings
- Events
- Setting up Event Handlers
- Package configuration
Module 6: Ad hoc tasks and transformations
- Creating .NET tasks
- Creating .NET data sources
- Creating .NET transformations
- Creating .NET data destinations
- Introducing custom components
Module 7: Administration
- Executing Packages
- Migrating DTS2000 packages
- Package deployment
- Integrating packages in .NET applications
|