SSIS Components

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