SSIS Solutions

SSIS Solutions

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

Overview/Description
SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. This course covers SSIS catalog creation and package deployment.

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)
0.8

Lesson Objectives

SSIS Solutions

Start the course

understanding the SSIS catalog

backup and restore the SSIS catalog

upgrade the SSIS catalog

create a deployment utility

deploy SSIS packages using the deployment utility

deploy SSIS packages to SQL or file system locations

deploy packages on multiple servers

validate deployed packages

install custom components and tasks

deploy SSIS packages using DTUTIL

Course Number:
md_idwm_a16_it_enus

Expertise Level
Intermediate