SSIS Components


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



Overview/Description
SSIS can be installed during the SQL Server installation or as a separate component. Before installation, there are a number of factors needing consideration, such as upgrade options and architecture. This course will cover SSIS components.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.7

Lesson Objectives

SSIS Components

  • start the course
  • describe SSIS components
  • prepare to install integration services
  • recognize the various SSIS configurations
  • install integration services using the setup wizard
  • use the SSIS designer graphical tool
  • describe when and how to use the development box and server
  • install specifics for remote package execution
  • plan for a 64-bit installation
  • upgrade SSIS components
  • provision accounts
  • create the catalog
  • describe catalog object identifiers
  • configure a catalog
  • install integration services using the setup wizard
  • Course Number:
    md_idwm_a13_it_enus

    Expertise Level
    Intermediate