• Online, Self-Paced
Course Description

Microsoft SQL Server Integration Services (SSIS) is a platform that can be used to build packages for data warehousing. This course will demonstrate how to create simple SSIS packages and also explain script tasks.

Learning Objectives

SSIS Package Execution

  • start the course
  • plan and design a package execution strategy
  • schedule package execution using SQL Server Agent
  • implement package execution
  • execute packages by using SQL Server Management Studio (SSMS)
  • monitor the execution using Management Studio
  • execute packages using DTEXEC and DTEXECUI
  • use PowerShell to execute SSIS packages
  • describe ETL restartability

Script Tasks in SSIS

  • determine appropriate use of script tasks
  • extend the capability of a control flow
  • perform a custom action during a control flow

Practice: Implementing Data Flow

  • use data flow to load data in SQL Server 2014

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development