Microsoft SQL Server 2008 Integration Services

Course:  SQLSIS
Duration:  4 Days
Level:  I
Course Summary

This course will help students become comfortable and productive with the SSIS tools and technologies. Students will learn about the Business Intelligence Development Studio (BIDS) and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. They will also become familiar with SSIS package management and package deployment including debugging, error handling, and logging techniques.

« Hide The Details
Topics Covered In This Course

Overview of Integration Services

  • SQL Server SSIS, SSAS, and SSRS
  • Integration Services Package in BIDS
  • Packages Outside of BIDS

Control Flow

  • Overview
  • Workflow Tasks
  • Precedence Constraints

Data Flows

  • Task overview
  • Data Viewers
  • Transformations

Variables and Configurations

  • Overview
  • Variables in Control Flow
  • Variables in Data Flow
  • Configurations
  • Variables and Configurations between Packages

Advanced Control Flow

  • Overview
  • Containers
  • Transaction Support in Integration Services

Error Handling and Logging

  • Troubleshooting
  • Checkpoints
  • Handling Errors and Debugging
  • Packaging Logging
  • Event Handling

Advanced Data Flow

  • Synchronous and Asynchronous Transformations
  • Using Advanced Transformations
  • Handling Slowly Changing Dimensions

Package Deployment

  • Overview
  • Create a Package Deployment Utility
  • Installing a Package
  • Redeploying Updated Packages

Package Management

  • Overview
  • Managing Integration Services Packages
  • Executing Packages
  • Integration Services Security

Scripting and Custom Components

  • Extending Integration Services Capabilities through Code
  • Control Flows with the Script Task
  • Data Flows with the Script Component
  • Custom Integration Services Components

Best Practices

  • Using Integration Services
  • Package Development and Design
  • Data Flow
  • Deployment and Management

Beyond ETL

  • Migrating and Maintaining SQL Servers
  • Analysis Services and MDX
  • Windows Management Instrumentation
What You Can Expect

At the end of this course, students will be able to:

  • Use BIDS to create well-designed packages
  • Understand Control Flows; how to build them using many of the built-in tasks, including the various containers
  • Use the Data Flow task to perform primary ETL operations
  • Understand variables and configurations in order to make their packages dynamic and resilient to changes in environments
  • Understand the features in BIDS and Integration Services that help with troubleshooting a package
  • Deploy and manage packages effectively
  • Write script so that they can go beyond the built-in tasks, data sources and destinations, and transformations, as well as build and use custom components
  • Understand best practices that will make it easier to develop and maintain a package over its entire life cycle
  • Use Integration Services for tasks other than traditional ETL operations
Who Should Take This Course

This course is designed for individuals who are IT professionals and developers.

Recommended Prerequisites

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.

Training Style

Instructor led with 50% lecture and 50% lab

« Hide The Details
Related Courses
Code Course Title Duration Level
DWHTCA
Data Warehousing Terms, Concepts and Architecture
1 Day
I
Details
DWHASP
Data Warehousing (DW) – Advanced SQL Queries & Performance
2 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com