MS203: Implementing and Maintaining SQL Server Integration Services
In this SQL Server Integration Services (SSIS) training class, students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
This SSIS class targets 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.
Duration: 24 Hours
Learn to describe SQL Server Integration Services and its tools.
Learn to create an Integration Services package.
Learn to implement control flow in an Integration Services package.
Learn to implement data flow in an Integration Services package.
Learn to implement logging in an Integration Services package.
Learn to debug and implement error handling in an Integration Services package.
Learn to implement checkpoints and transactions in an Integration Services package.
Learn to deploy an Integration Services package.
Learn to manage and secure an Integration Services package.
Introduction to SQL Server 2008 Integration Services
Overview of SQL Server Integration Services
Using Integration Services Tools
Lab: Introduction to SQL Server Integration Services
Developing Integration Services Solutions
Creating an Integration Services Solution
Building and Running a Solution
Lab: Developing Integration Services Solutions
Implementing Control Flow
Control Flow Tasks
Control Flow Precedent Constraints
Control Flow Containers
Lab: Implementing Control Flow
Implementing Data Flow
Data Flow Sources and Destinations
Basic Data Flow Transformations
Advanced Data Flow Transformations
Data Flow Paths
Lab: Implementing Data Flow
Overview of Integration Services Logging
Enabling and Configuring Logging
Lab: Implementing Logging
Debugging and Error Handling
Debugging a Package
Implementing Error Handling
Lab: Debugging and Error Handling
Implementing Checkpoints and Transactions
Lab: Implementing Checkpoints and Transactions
Configuring and Deploying Packages
Lab: Configuring and Deploying Packages
Managing and Securing Packages
Lab: Managing and Securing Packages