• 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 Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.