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